Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to use the Index and Match lookup functions in Microsoft Excel. They are better to use than the Vlookup function; in fact, never use the Vlookup function again (unless truly needed). The index and match functions allow you to search any column in a table and return data from any column in a table and therefore eliminates the restriction imposed by Vlookup that the lookup value must always be in the leftmost column of the table. This is a great set of excel functions and formulas to learn. It will save you a lot of time when searching your excel spreadsheets.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachMsOffice.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• index function
• match function
• excel guides and help
• learn to use excel
• formulas in excel
• search a table in excel
• never use vlookup again

[bigcumfy]

Thanks!! Very easy. I tried to decipher a coworkers formula for over an hour to figure out how to return a diferent column. It took me less than 5 min to do my own after watching this vid once!!! Easy peazy!!! Thanks, I really appreciate it!!!

[ExcelisHell]

@bigcumfy Glad it was helpful :)

[ExcelisHell]

@bigcumfy Glad it was helpful :)

[R08x]

Thanks this was very helpful

[xtoet]

THANKS MAN!

[yoojeongc]

Thank you for this!

I was able to complete my assessment on index/match after watching your tutorial.

[amattehmaphia]

gosh, this clarifies index and match very well... excellent vid!

[9LoL1]

Hey!

Thanks 4 uploading this tutorial it is very helpful! and I've used it in my project

but i have a question... using your example how could you find an ID number if u have both the Part and Cost values?

thanks