Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replacing the row index in HLOOKUP | Excel Worksheet Functions | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Index / Hlookup | Excel Worksheet Functions | |||
cell reference from hlookup | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions |