Finding TRUE/FALSE w/VLOOKUP @ multiple values

[WSBirch]

Good afternoon,
Trying to wrap this around my head and it's just not happening.

In the example below, I just want to know in column F if the color BLUE appears at all in the reference # over in column B.
I've realized that VLOOKUPs just stop at the first value it comes across from top-down, so while a VLOOKUP would work for REF# 3 @ cell A7, it does not work for REF# 6 or 7 @ cells A12:A13 or A14:A18.

In column F, I just want to know if REF# in column E has the value "BLUE" appear for that REF# over in column A at all.

All help would be greatly appreciated, thank you!!

 

[philwojo]

You could try this on sheet-2, update cell references as needed:

=IF(COUNTIFS(Sheet1!$A$5:$A$18,$A5,Sheet1!$B$5:$B$18,"Blue")>0,"True","False")

There are other ways to do this I'm sure.

Phil

 

[WSBirch]

Works like a charm, thank you!!!

 

[philwojo]

Glad to help.