Excel: If in list

[SQLScholar]

Hey,

If i had the below sheet

a 1
b 2
c 3

then in another sheet i had

2
1
3
1

Then i wanted a column which said

find the figure in the other sheet.... if its corrisponing character is B then put yes otherwise put know

so it would be

2 yes
1 no
3 no
1 no

how would i do this coloum

Cheers

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[RivetHed]

Hi,

If you don't mind reversing the order of the columns in sheet1 you could just do a vlookup, so:

=IF(VLOOKUP(A1,sheet2!$A$1:$B$3,2,FALSE)="b","Yes","No&quot

if this is all your trying to achieve then this should suffice