Determining if a value exists in a column

[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

 

[Paul Sheppard]

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

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?

 

[Trevor Shuttleworth]

You could use COUNTIF or VLOOKUP as a couple of options.

Regards

Trevor