Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Difference between VLOOKUP and HLOOKUP

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-01-2009
Member
 
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
Reply With Quote
  #2  
Old 23-01-2009
Member
 
Join Date: May 2008
Posts: 4,564
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.
Reply With Quote
  #3  
Old 23-01-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Difference between VLOOKUP and HLOOKUP

For more details on VLOOKUP and HLOOKUP see this http://office.microsoft.com/en-us/ex...CH062528281033
http://office.microsoft.com/en-us/ex...CH062528281033
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Difference between VLOOKUP and HLOOKUP"
Thread Thread Starter Forum Replies Last Post
How to get yes or no in Vlookup in Excel Gurmeet MS Office Support 2 24-01-2012 03:57 PM
duplicate vlookup help saif49 Windows Software 1 12-11-2010 03:57 PM
Use VLookup in vba mellisahi Software Development 3 11-09-2009 05:33 PM
Using vlookup function Please help CheckMeNot Windows Software 3 25-06-2009 09:28 AM
Need help for vlookup function Sunny55 Windows Software 4 09-05-2009 12:39 PM


All times are GMT +5.5. The time now is 12:29 AM.