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?