Excel Forum

Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors

Formula for VLOOKUP with Two Lookup Values that must return all values in a table that has the lookup values as row and column headers. See how add extra column with unique identifier to data set using ampersand concatenate.

Also see how to track down errors in spreadsheet by:
1)Check Formula
2)Check data source
3)Sort to visually check data
4)Check Formulas Inputs
5)Run Formula Evaluator
6)Check For Spaces in Formula Inputs
7)Discover that extra spaces cause formula errors

Also see this video title:

Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also)

Got a Question? Ask it Here in the Forum.