Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hlook function
what is the difference between vlookup & hlook up function. i am good in
vlook up but do not have any clue about hlook. can any one help me out with eg. Thanks a lot for your help |
#2
|
|||
|
|||
Exactly the same except you are searching through Rows rather than Columns.
-- David Billigmeier "Ankur" wrote: what is the difference between vlookup & hlook up function. i am good in vlook up but do not have any clue about hlook. can any one help me out with eg. Thanks a lot for your help |
#3
|
|||
|
|||
This example may help:
You have a financial report with Division Names as column headings (Corp, East, etc). You want to find a given divsion and pull the 4th number down from that Col Heading. A1: =HLOOKUP("Corp",ReportRange,5,0) Note: I use 5 because the Col Heading counts as a row. Does that help? -- Regards, Ron "Ankur" wrote: what is the difference between vlookup & hlook up function. i am good in vlook up but do not have any clue about hlook. can any one help me out with eg. Thanks a lot for your help |
#4
|
|||
|
|||
Thanks Ron,
Now my doubt is clear with eg you have given. "Ron Coderre" wrote: This example may help: You have a financial report with Division Names as column headings (Corp, East, etc). You want to find a given divsion and pull the 4th number down from that Col Heading. A1: =HLOOKUP("Corp",ReportRange,5,0) Note: I use 5 because the Col Heading counts as a row. Does that help? -- Regards, Ron "Ankur" wrote: what is the difference between vlookup & hlook up function. i am good in vlook up but do not have any clue about hlook. can any one help me out with eg. Thanks a lot for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |