Complicated IF Array

[Hannah122392]

Hello,

I need help with a complex (to me) IF statement. Here is the link to the sheet I am working on:

https://docs.google.com/spreadsheets/d/1RbJJknpUzxzi4eGcju7nD0N_X9wfb69uCpunZQxayC4/edit?usp=sharing

What I need is on Friday Poles A13 - I need a formula to check Friday Poles D13:F13 against the Master Entry List A2:C2 if it matches, check M2 to see if it has a 1. If it does return a Yes, if not leave blank. If Friday Poles D13:F13 doesn't match A2:C2, check the next cell, so on and so forth.

Thanks for any and all help!

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...if-criteria-matches-and-column-has-a-1-a.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Hannah122392]

Yes, I was going to delete this post, however I can't.

 

[Fluff]

You do not need to delete it, you just need to let us know.

 

[Hannah122392]

Cross posted here due to inability to delete this thread:
https://www.excelforum.com/excel-fo...if-criteria-matches-and-column-has-a-1-a.html

 

[Hannah122392]

However, I would prefer if this current thread was deleted.

 

[Fluff]

Thread closed at OP's request