Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default what are the uses for Vlookup and Hlookup?

I need to know what are some of the uses for Vlookup and Hlookup functions.
When they would be useful and the easiest way to use them.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default what are the uses for Vlookup and Hlookup?

There's an example he

http://contextures.com/xlFunctions02.html

Try it out and you'll see how useful it can be!

Biff

"aeroluv" wrote in message
...
I need to know what are some of the uses for Vlookup and Hlookup functions.
When they would be useful and the easiest way to use them.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default what are the uses for Vlookup and Hlookup?


You should also get real comfortable with the Index function, and you
can nest the match function within it to assign row and column numbers.
That's sort of like combining vlookup and hlookup into one.


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=569290

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing the row index in HLOOKUP Martin Smith Excel Worksheet Functions 5 May 31st 06 03:10 PM
Problem with HLookup - Sometimes works, sometimes blank. Regnab Excel Discussion (Misc queries) 3 May 22nd 06 04:09 AM
Index / Hlookup Pamela Creighton Excel Worksheet Functions 1 February 5th 06 07:22 PM
cell reference from hlookup warrenb Excel Worksheet Functions 4 January 5th 06 01:30 PM
Need help with HLOOKUP and MATCH functions BEAR94 Excel Worksheet Functions 1 August 12th 05 05:36 AM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"