Match

A

Anita

Hi

I've got 2 columns of data and want to find out if a value in col A exists
anywhere in column B - I thought the match function might do this but I can't
work it out.

Thanks

Anita
 
B

Bob Phillips

=ISNUMBER(MATCH(A2,B:B,0))

will return TRUE or FALSE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
S

Soundar

Hi Anita,

You can do this by using COUNTIF function, Please find the below example:

ColA ColB ColC

RAJ RAJ 1
RAM KUMAR 1
KUMAR RAJ 1
JOHN MIKE 0

Forumula used in cell C1 is as follows

=COUNTIF($A$1:$A$4,B1)

If a value in Col A is also there in Col B then it will display value '1' in
ColC, otherwise (i.e value in col B is not in col A) it will display value
'0' in column C.

Hope this will clear your doubt.

Regards,
Soundar.
 
Top