Hi, say if I had a spreadsheet as follows:
A B C D
1 E 3
2 E 6
3 E 6
4 C 6
5 C 6
6 C 4
7 D 4
8 D 3

I want to run a function that will return a single item from column A, i.e
my new column will contain:
E
C
D

And I want the function to tell me if this letter had a 3 next to it, so it
would return:
E Yes
C No
D Yes

Obviously I'm applying this to a much longer list or I'd manually look it
up, I'm sure there must be a simple way of doing this which I'm overlooking?