Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Vlookup what does that mean. (https://www.askmehelpdesk.com/showthread.php?t=290986)

  • Dec 11, 2008, 09:42 AM
    ronex
    Vlookup what does that mean.
    Can any one tellme.. what does vlookup formula mean in excel...
  • Dec 11, 2008, 03:14 PM
    missmarple

    Basically the V means Vertical so looking for a code/data count the Columns across to see what column the data you wish to find is in and type in a number (number of columns starting from left)
    This is only a guide..
  • Dec 12, 2008, 01:42 AM
    JBeaucaire

    Vlookup means look for a value down a range of rows, and when the value is found, bring back a matching piece of data from the same row a few columns away.

    HLookup does the same thing, but it does it across columns.

    Lookup formulas are great when you have one sheet with a lot of organized data, like names, addresses, phone numbers, etc.

    Then on another sheet, you type a name in a cell, and LOOKUP formulas look at that name, go over to your list of data, find the name, then bring back key pieces of related info... like phone numbers, in an adjacent cell.
  • Dec 12, 2008, 10:13 AM
    ronex

    That was definitely some piece of information.. thanx a lot guys

  • All times are GMT -7. The time now is 09:20 PM.