Excel Lookup Series #2: VLOOKUP Function 2nd Example

Tags:
Colleges Column Community Data Exact Excel Function Gel Girvin Highline Mike Name Validation Value Vlookup
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 429
  • Added: 29-Apr-08

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.

  1. Categories: Science & Tech
Comments on

Excel Lookup Series #2: VLOOKUP Function 2nd Example

10 Comments | Add Comment
  • Dear shiryu008, ...

    Dear shiryu008,

    Oh man, I am clueless (have no idea) about Spanish shortcuts.

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1219868921 Reply Spam Moderate Up Moderate Down
  • Ok, that my second ...

    Ok, that my second video on the row. let head for the third. hey mike, i usualy use excel but the spanish version. It's amazing to know the equivalent of the function in english version. however, the keyboard shortcut are not always the same :( ;(. Any advice?
    thanks.

    By shiryu008 [Affiliate User] 1219862626 Reply Spam Moderate Up Moderate Down
  • Dear royvaibhav, ...

    Dear royvaibhav,

    No Genius, just having fun with Excel!!!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1218987404 Reply Spam Moderate Up Moderate Down
  • Dude, you're a ...

    Dude, you're a Genius!!

    By royvaibhav [Affiliate User] 1218958953 Reply Spam Moderate Up Moderate Down
  • Dear periwink, ...

    Dear periwink,

    Thanks!!!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1217471807 Reply Spam Moderate Up Moderate Down
  • Periwink gives you ...

    Periwink gives you 5 stars :)

    By periwink [Affiliate User] 1217468464 Reply Spam Moderate Up Moderate Down
  • Dear jabberwokiuk, ...

    Dear jabberwokiuk,

    EXCELlent!!! I glad you find them useful. I'll keep making videos if you keep watching (and rating too!).

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1213716060 Reply Spam Moderate Up Moderate Down
  • Great videos and ...

    Great videos and very much appreciated. I stumbled across your work yesterday and couldn't believe my eyes when I saw the number of videos you have produced, covering a very comprehensive range of Excel tools and features. WOW!

    Thanks

    By jabberwokiuk [Affiliate User] 1213696419 Reply Spam Moderate Up Moderate Down
  • Dear skykam, You ...

    Dear skykam,

    You are so rad and cool. Thank you for this EXCELlent suggestion! It took me a few days to find the time, but I have all my video series set up as video responses.

    skykam and anyone else, please give me useful and efficient suggestions, and I will implement them if they make it better for our YouTube Excel Team!!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1211659595 Reply Spam Moderate Up Moderate Down
  • Very useful. Thank ...

    Very useful. Thank again.

    One suggestion: To make it easier to make it more obvious which video is the next in the series, you may want to post that video as "video response" to yourself. When you approve it, the resulting video will show up right under this video.

    By skykam [Affiliate User] 1211339346 Reply Spam Moderate Up Moderate Down
10 Comments | Add Comment