|
Featured Tutorial
Featured Macro
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)
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)