Multiple IF conditions

[venky2002]

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

Product	Formula required EOS
A	YES
B	NO
C	YES
D	NO

Sheet 2

Product	Scenario	EOS
A	Initial	4/4/2022
B	Expansion	4/4/2022
C	Initial	4/4/2022
D	Extension	4/4/2022

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1	Product	Scenario	EOS
2	A	Initial	04/04/2022
3	B	Expansion	04/04/2022
4	C	Initial	04/04/2022
5	D	Extension	04/04/2022
Sheet2

Fluff.xlsm
	A	B
1	Product	Formula required EOS
2	A	Yes
3	B	No
4	C	Yes
5	D	No
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=IF(COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,"Initial",Sheet2!C:C,"<>"),"Yes","No")

 

[venky2002]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1	Product	Scenario	EOS
2	A	Initial	04/04/2022
3	B	Expansion	04/04/2022
4	C	Initial	04/04/2022
5	D	Extension	04/04/2022
Sheet2

Fluff.xlsm
	A	B
1	Product	Formula required EOS
2	A	Yes
3	B	No
4	C	Yes
5	D	No
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=IF(COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,"Initial",Sheet2!C:C,"<>"),"Yes","No")

Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[venky2002]

Thank you so much

what if i need to return the EOS date instead of yes for same condition, and blanks instead of NO

 

[Fluff]

Will the product only appear once on sheet 2 with Initial in col B?

 

[venky2002]

for the same condition I need date’s for initial condition of column b in sheet 2, if there are dates for initial in column c sheet 2 , I need the date for initial to populate in column b of sheet 1 , for other conditions other than initial in sheet 2 column c should return blank in column b sheet 1

 

[Fluff]

That does not answer my question.

 

[venky2002]

Y

Will the product only appear once on sheet 2 with Initial in col B?

Yes only once in sheet two

 

[Fluff]

In that case, how about

=IF(COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,"Initial",Sheet2!C:C,"<>"),SUMIFS(Sheet2!C:C,Sheet2!A:A,A2,Sheet2!B:B,"Initial"),"No")