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...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.