Match

[treborharris]

I have two columns of numbers and I wish to make a 3rd column which compares col B and returns Yes or No if the number is used in col A

Can some suggest which function please

[Ron Coderre]

With
A1:B10 containing numbers

This formula returns Yes if the Col_B number exists in Col_A, otherwise: No....
C1: =IF(COUNTIF($A$1:$A$10,B1),"Yes","No")

Copy C1 down as far as you need
(Adjust range references to suit your situation)

Does that help?

Regards,

Ron
Microsoft MVP (Excel)

[treborharris]

Many thanks

it did the job well

[Ron Coderre]

I'm glad I could help........Thanks for letting me know.


Regards,

Ron
Microsoft MVP (Excel)