Comparing 2 columns of numbers with multiple numbers in first columns

[sylviexcel]

I am trying to compare 2 columns of numbers, one column (D1) where the numbers may be repeated. I need to check if the numbers are listed in the second column and if they are return a Yes in a seperate column (F1). I have named the second column data2 (this has unique numbers) and tried the formula below which I found on the site but it is returning some inaccurate data, any help greatly appreciated.

=IF(ISNUMBER(MATCH(D1,data2)),"yes")

 

[Aladin Akyurek]

I am trying to compare 2 columns of numbers, one column (D1) where the numbers may be repeated. I need to check if the numbers are listed in the second column and if they are return a Yes in a seperate column (F1). I have named the second column data2 (this has unique numbers) and tried the formula below which I found on the site but it is returning some inaccurate data, any help greatly appreciated.

=IF(ISNUMBER(MATCH(D1,data2)),"yes")

Try...

=IF(ISNUMBER(MATCH(D1,data2,0)),"yes","")

 

[sylviexcel]

Will do thanks for quick reply

 

[sylviexcel]

Nearly there but still returning the odd number that is not in second column?? thanks

 

[sylviexcel]

Thanks this worked the second time around