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 Ma...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
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 436: VLOOKUP W 4 Lookup Columns


See how to use VLOOKUP when the first four columns of the lookup table must be used for the lookup value. The data is badly setup up because it is an import into Excel from a database. See VLOOKUP, IF and IFERROR functions.





Got a Question? Ask it Here in the Forum.