Thread: lookup formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default lookup formulas

A vlookup, returns values to the right in a range of the found cell,
=vlookup(a1, C1:D5, 2, false) returns the value one column to the right of
the found cell, which is the 2 argument.
--
David


"cquatro" wrote:

I would like to create a lookup formula that will return info in the cells
adjacent to the cell with the info in the lookup, is this possible?
--
cquatro