Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Vlookup Partial Match in Excel
Tutorial: Return Vlookup results on partial matches of a cell's contents. You could type the start, ...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...

# Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH

See how to do Two 2 way lookup with VLOOKUP & MATCH functions. Two way lookup can be done at least three ways with formulas that include:
1) INDEX and MATCH functions
2) INDIRECT functions and the space operator
3) VLOOKUP & MATCH functions

YTL Excel #119: Amazing Lookup Solution!
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
MrExcel's Learn Excel #965 - Two-Way Lookup
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH

Got a Question? Ask it Here in the Forum.