View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default What is the difference between VLookup and HLookup tables

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