Vloggest Entertainment

Watch all your favorite videostars!
  • Share this video
  • facebook
  • Google+
  • Twitter
  • submit to reddit Reddit
  • Tags
  • Show tags

Excel Lookup Series #2: VLOOKUP Function 2nd Example

ExcelIsFun Follow
  • Video description
  • 12 years ago
  • 191,138 views
  • 345 likes
  • 120 comments
Download Excel Files:
Start File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelLookupFunctionsSeries1-15.xls

Finished File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelLookupFunctionsSeries1-15%20Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

See how to use the VLOOKUP function to deliver a value to cell from the 3rd column of the table using the COLUMN function.

Find exact value from column 2 and column 3 of lookup table using the COLUMN function.

Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate.


In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.
Vlogger of the day:

KSI

"I had no clue on what I wanted to do when I was younger, so I was pretty lucky with this YouTube thing.” Olajide "JJ" Olatunji (born 19 June 1993), better known by his online pseudonym, KSI, is an...

read more

  • Comments
  • Related videos