Determining if a value exists in a column

  • Thread starter Thread starter Lord MJ
  • Start date Start date
L

Lord MJ

I have a spreadsheet with one column of data, and I want to check al
the values in that column to see if they exist in another column o
data.

What types of formulas or operations exist in excel that will allow m
to accomplish this?

Michae
 
Lord said:
I have a spreadsheet with one column of data, and I want to check all
the values in that column to see if they exist in another column of
data.

What types of formulas or operations exist in excel that will allow me
to accomplish this?

Michael
Click to expand...

Hi Michael

Try this, assuming your columns of data are next to each other

=IF(ISERROR(VLOOKUP(A2,B2:B5,1)),"No match","Match")

ps are you an ex Royal Mail employee from Southampton/Portsmouth?
 
Back
Top