Excel Forum
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 Mat...
Vlookup with a Range of Numbers in Excel
Tutorial: How to use the Vlookup function to return a result that falls within a range of numbers, s...
Easily Input Complex Functions in Excel
Tutorial: In this tutorial I am going to show you how to easily input complex Functions in Excel. To...



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.