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

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

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

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