=IfMatchthen"Yes" help

[USMCFROSTY]

In ms Excel 2010 i have 2 columns (A,B). I am trying to see if my numbers in b match the ones in a and if they do put yes in c. Example--- a has # 1-1000 and b has 1-50 so i want to look at the number in b1 and if it is a match in the range of a1:a1000 then put "yes" in c1. I tried match, index, and v lookup but keep getting errors.

 

[Brianwarnock]

You haven't said what you tried or what errors but try something along these lines

=IF(ISNA(VLOOKUP(B1,A$1:A$100,1,FALSE)),"NO","YES")


Brian

 

[NBVC]

Also,

=IF(ISNUMBER(MATCH(B1,$A$1:$A$100,0)),"Yes","")