Match

[Guest]

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

 

[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)

 

[Guest]

Anita,

Lots of methods fo duplicates here:-

http://www.cpearson.com/excel/Duplicates.aspx

Mike

 

[David Biddulph]

=IF(ISNA(MATCH(A1,B:B,0)),"Not found","Found")

 

[Guest]

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.