Excel Lookup Series #1: VLOOKUP Function 1st Example

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

See how to use the VLOOKUP function to deliver a value to cell:
1) Find approximate value from column 2 of lookup table.
2) Find exact value from column 2 of lookup table.

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.

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

  1. Categories: Science & Tech
Comments on

Excel Lookup Series #1: VLOOKUP Function 1st Example

5 Comments | Add Comment
  • yes, it helped me ...

    yes, it helped me with my uni assignmnet :-). The notes I had only had a step by step guide, I just got some cells mixed up when I entered in the formula, but I got it now :-)

    By marmlr339 [Affiliate User] 1241963982 Reply Spam Moderate Up Moderate Down
  • Dear marmlr339, ...

    Dear marmlr339,

    I am glad that you liked it!

    --excelisfun

    By ExcelIsFun [Affiliate User] 1241963714 Reply Spam Moderate Up Moderate Down
  • very useful video!! ...

    very useful video!!! Thanks so much :-)

    By marmlr339 [Affiliate User] 1241957119 Reply Spam Moderate Up Moderate Down
  • thanks very much I ...

    thanks very much I am downloading as I write this

    By thinkverypositive [Affiliate User] 1241455228 Reply Spam Moderate Up Moderate Down
  • Dear ...

    Dear thinkverypositive ,

    Search for and watch this video:

    Search For Excel Videos Download Excel Files excelisfun

    In this video I show the link that allows you to download my free book. And also, at the end, I mention my four favorite Excel books. Here is a note on each:

    For a basics book, use my Free book.
    For a great reference book use Mr Excel's Special Edition book
    For a great solving business problems book use the Succeeding in Business book.

    --excelisfun

    By ExcelIsFun [Affiliate User] 1241441576 Reply Spam Moderate Up Moderate Down
5 Comments | Add Comment