Excel Forum
Similar Content
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...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for ...



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


See how to use the VLOOKUP function when you have two lookup values for each record. Learn how to use the IFERROR function also, and how to join two cells to add a new first column to the lookup table for the VLOOKUP function. Ampersand symbol to join cell content.

VLOOKUP with Two Lookup Values
VLOOKUP with 2 Lookup Values
VLOOKUP with Two Lookup_Value
VLOOKUP with 2 Lookup_Value





Got a Question? Ask it Here in the Forum.