View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
plc plc is offline
external usenet poster
 
Posts: 2
Default 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