lookup formulas
 

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

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

lookup formulas
 

You could use either a VLOOKUP or INDEX/MATCH for the job in the formula cell

Browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

lookup formulas
 

Sure thing,

Without a bit more information on your ranges, and what you're trying to
get back, though, all I can really recommend to you is that you look up
Vlookup and Hlookup in the help files.

Do be aware that to get an exact match, you will want to add the ,False
argument to the end of the formula though. (This will make more sense
when you review the help file.)

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

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?