2 ANSWERS, 1 cell

[Smokin_Joe]

I will try my best explain...

CELL E3 CONTAINS THIS IF FORMULA...

=IF(D3="OUT","YES","NO")

NOW I NEED E3 TO RETURN "NO" IF D3="OUT" AND A3 IS A MATCH IN G3:G13 & STILL BE ABLE TO RETURN "YES" IF D3="OUT"

I HOPE THIS EXPLAINS IT.

[TMS]

Misread the question

[TMS]

Maybe this:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Hi and welcome
please note that writing in Capital Letters is the equivalent of shouting ( or are you mad at us?)

Also be aware that "Hello" or "Thank you" are appreciated by the volunteers manning this forum and are not considered coarse language

[Smokin_Joe]

Sorry...I have been staring at my monitor for a couple days now trying to figure this out...I didn't even notice the CAPS...

And yes Hello, and any help would be appreciated please and thank you.

[Sam Capricci]

you were given an answer by Trevor in post # 3, have you tried it? It looked to me like it worked in your posted workbook.

[Smokin_Joe]

Hello, thank you TMS, that formula worked perfectly.

[TMS]

You're welcome. Thanks for the rep.