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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Index and Match 8
Lookup returning wrong results 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Comparison of columns using Conditional Formatting 3
Compare 1 cell to column of cells returning adjacent cells info? 1
Excel Highlighting duplicates 0
Match function: error due to format? 4

Back
Top