Title:
How to Lookup Values Using Multiple Columns in Excel
Video:
Description:There are times when you need more look up power than you can get from the VLOOKUP Function. For example, when you need to return a value that requires you to look up more than one column (eg First Name -1st Column - and Last Name - 2nd Column) in order to return the employees title or manager or hire date. I share my best practices in this lesson - eg using Named Cell Ranges in your Formula. To create this formula you are using an Array Formula and this means that you use the keyboard combination "Ctrl+Shift+Enter" to enter it. Please visit my online shopping website - shop.thecompanyrocks.com - to view additional videos and to access my many resources, I also welcome your comments. Tell me if my video has helped you or suggest additional video lessons for me to post here on YouTube. Danny Rocks
Published:
28/Oct/2010
How to Lookup Values Using Multiple Columns in Excel
Video:
Description:There are times when you need more look up power than you can get from the VLOOKUP Function. For example, when you need to return a value that requires you to look up more than one column (eg First Name -1st Column - and Last Name - 2nd Column) in order to return the employees title or manager or hire date. I share my best practices in this lesson - eg using Named Cell Ranges in your Formula. To create this formula you are using an Array Formula and this means that you use the keyboard combination "Ctrl+Shift+Enter" to enter it. Please visit my online shopping website - shop.thecompanyrocks.com - to view additional videos and to access my many resources, I also welcome your comments. Tell me if my video has helped you or suggest additional video lessons for me to post here on YouTube. Danny Rocks
Published:
28/Oct/2010
No comments:
Post a Comment