Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns

4,978 views · Published 2 November 2009 · 6:43 · Indexed 1 October 2026

Channel: excelisfun · 2009 · Science & Technology

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT431-439.xls

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.

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,557 views · 23 May 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,669 views · 4 August 2008

• 4:16 YTLE#82: Enter UPPER Case Text Only Into The Cell

  excelisfun

  2,676 views · 7 August 2008

• 3:22 YTLE#93: "Go To Special Blanks" Caveat

  excelisfun

  1,663 views · 12 August 2008

• 6:24 YTLE#104: Find 1st Positive# in Excel List

  excelisfun

  3,872 views · 30 August 2008

• 4:50 YTL Excel #123: Array Formula To Count E-mails

  excelisfun

  2,540 views · 11 September 2008

• 0:03 Family At Christmas Tree

  excelisfun

  4,723 views · 3 January 2009