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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks