Blog About Stuff That's In Your Home | Appliances and Stuff

07 Nov 11 Excel Lookup Series #1: VLOOKUP Function 1st Example

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!

Tags: Example, Excel, Function, Lookup, Series, VLOOKUP

Reader's Comments

  1. |

    @AnnihilationXable , great! Good luck with doing EXCELlently on your exam tomorrow!!!

  2. |

    Hey, thanks so much for the tutorial, I have an Excel exam tomorrow and I don’t think my teacher did a very good job explaining this. Now I’m certain I’m gonna do better than everyone else, thanks again!!

  3. |

    hi how do i download this specific video from your site, i tried finding it, but could not get it. pls do tell

  4. |

    this guy sounds like Kyle Cease

  5. |

    I am glad it all helps!

  6. |

    You are welcome!

  7. |

    You are welcome!

  8. |

    WOW!!! I am extremely grateful to have found you! i have been searching all over for excel tutoring. you are a tremendous help and blessing. Thank you!

  9. |

    Thanks for you video; however, Can we use the vlookup to lookup at the “lookup value” that more than one cell. Such as not only one cell as “lookup value”, but many cell as “lookup value”?

  10. |

    @suruchigupta2k3 – a list of .xls files as long as your arm . Also a lot of pdf’s and ” Excel2007IsFun!.doc Book (Free book!) ” . regards

  11. |

    @suruchigupta2k3 me too can’t and also­celIsFun.htm
    this link 1 to 15

  12. |

    Y___Y, like like, very funny and useful ! Thanks !

  13. |

    You are welcome!

  14. |


  15. |

    Thanks once again!

  16. |


  17. |

    Hi, I Cannot find the workbook for this. Please let me know the link … Thanks!

    And thanks a lot for these videos.. they are just awesome.

  18. |

    After you create the numbers, you have to copy them, then Paste Special, Values.

  19. |

    How do you create a huge random data set? I tried using RANDBETWEEN but don’t know how to turn off the rand once I get my numbers

  20. |


  21. |

    Cheers, you have just made me look very clever in my bosses eyes hehe

  22. |

    You are welcome!

  23. |

    thank you soooo much for your work in which contributes a great amount of useful excel skills to people like me. I appreciated man. thank you so much once again.

  24. |

    Here is a video:

    Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
    Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example

  25. |

    hi. awesome videos. is it possible to use VLOOKUP for income tax calculations in Excel?