Results 1 to 3 of 3

Thread: Difference between VLOOKUP and HLOOKUP

  1. #1
    Join Date
    Aug 2006
    Posts
    287

    Difference between VLOOKUP and HLOOKUP

    What's the difference between HLOOKUP and VLOOKUP function in excel ? and which one is better and frequently used. i am using Excel 2003 it will be great if you could provide me examples of these functions. You can copy and paste them into a worksheet to see how they work.Thanks for your answers.
    Dimension 1100 (FMY032J) mini-tower
    2.53ghz Intel Pentium 4
    80 gig nfts HDD
    512 RAM
    Main circuit board: Dell 0CF458
    BIOS: Dell A00
    Display: Intel(R) 82865G Graphics Controller [Display adaptor]
    Multimedia: Sound MAX Integrated Digital Audio
    Windows XP Home SP2

  2. #2
    Join Date
    May 2008
    Posts
    4,574

    Re: Difference between VLOOKUP and HLOOKUP

    The vector syntax for LOOKUP looks for a matching value in a range of cells (vertical or horizontal) and returns the value in the matching vector position of the second supplied range. It is similar to VLOOKUP and HLOOKUP; however, it is limited to a single row or column to hold results.

    VLOOKUP looks for a matching value in the first column of a range of cells and returns the value from the same row in the column of the range you specify. The range can have multiple columns. LOOKUP would have only one column to choose from.

    To discribe the difference, I would say LOOKUP has a single column or row range to hold the lookup values, and a single column or row range to hold the return values. The return range does not need to be adjacent to the lookup range, but can be. VLOOKUP can have multiple columns, the first being the lookup column. The other columns hold the result values and are choosen by the column parameter. The VLOOKUP fucntion uses a single multi-cell range.

    Excel 2003 has excellent examples of these functions. You can copy and paste them into a worksheet to see how they work.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,644

    Re: Difference between VLOOKUP and HLOOKUP


Similar Threads

  1. How to get yes or no in Vlookup in Excel
    By Gurmeet in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 03:57 PM
  2. duplicate vlookup help
    By saif49 in forum Windows Software
    Replies: 1
    Last Post: 12-11-2010, 03:57 PM
  3. Use VLookup in vba
    By mellisahi in forum Software Development
    Replies: 3
    Last Post: 11-09-2009, 05:33 PM
  4. Using vlookup function Please help
    By CheckMeNot in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 09:28 AM
  5. Need help for vlookup function
    By Sunny55 in forum Windows Software
    Replies: 4
    Last Post: 09-05-2009, 12:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •