matching values

  • Thread starter Thread starter Donna Kostellar
  • Start date Start date
D

Donna Kostellar

I need to be able to look up a value from 1 cell in a
range of cells to find if there is a match and where the
match is

Can anybody help

Thanks
Donna
 
I need to be able to look up a value from 1 cell in a
range of cells to find if there is a match and where the
match is
Click to expand...

The MATCH function returns "the position of an item in a range instead of
the item itself". If the range of cells is B1:B??? and value to find is in
A1,

="B"&MATCH(A1,B:B,0)

returns the cell reference. If value is not found, you'll get #N/A.

HTH,
Andy
 
Back
Top