Determining if a value exists in a column

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
 
P

Paul Sheppard

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?
 
T

Trevor Shuttleworth

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

Regards

Trevor
 
Top