I have a list of products in sheet 1 and sheet 2, my query is to tag products in sheet one if the product is tagged as "initial" in one column and has a EOS date in other column, if both the conditions satisfies then in sheet 1 the formula should say "YES" if both the conditions doesn't satisfy then "No".
Sample data
Sheet 1
Sheet 2
Sample data
Sheet 1
Product | Formula required EOS |
A | YES |
B | NO |
C | YES |
D | NO |
Product | Scenario | EOS |
A | Initial | 4/4/2022 |
B | Expansion | 4/4/2022 |
C | Initial | 4/4/2022 |
D | Extension | 4/4/2022 |