Main Profile

At A Glance

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)
Length: 12:17

Contact

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

Want more info about Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question