Learn how to use the VLOOKUP formula in Excel and how to use INDEX MATCH to do simple table lookups. This vlookup tutorial is mostly for beginners. See the following article for more advanced uses: https://www.vertex42.com/blog/excel-f...

0:12 Simple VLOOKUP function example (return a price for a given item)
1:10 Same example using INDEX MATCH instead
1:58 How to use VLOOKUP in Excel to return vendor information (purchase order example)
3:12 How to use INDEX MATCH in a purchase order to look up unit prices

👍 Remember to Subscribe!

FOLLOW VERTEX42 HERE:
Facebook:   / vertex42  
Pinterest:   / vertex42  
Twitter:   / vertex42  
Website: https://www.vertex42.com/