What is the difference between VLookup and HLookup tables
thanks.
"JLatham" wrote:
For the gory details, see Excel Help and search for VLOOKUP and whatever
other lookups you're interested in (HLOOKUP() or just plain LOOKUP()).
VLookup searches down the leftmost column of a table for a match and returns
a value from a column to the right of the match on the same row.
HLookup searches left to right across a row of entries for a match and
returns a value from a row below the column the match was found in.
LOOKUP() allows you to look something up in one range and return a matching
item in another, similarly sized, range without it having to be to the right
of or below the range being searched.
"plc" wrote:
Just wondering
|