Could you please write me a function of the following scenario?

[dener123]

Cells	A	B	C	D
1	Team Names	Results	Sector	Values based on Sector
2	Product Team		223	0
3	Customization Team		224	0.2
4	Product Team		226	3

I need a function formula for Cell B2,B3,B4.
Scenario is:
If the certain Team in cell A's Sector(cell C)'s Values based on Sector (cell D) is <2, show Result (cell B) as Yes.
If it is =2, show Result as Maybe.
If it is >2, show Result as No.

Thank you!

 

[dreid1011]

Options:

Book1
	A	B	C	D
1	LOOKUP	IF	IFS
2	Yes	Yes	Yes	1
3	Maybe	Maybe	Maybe	2
4	No	No	No	3
Sheet2

Cell Formulas
Range	Formula
A2:A4	A2	=LOOKUP(D2,{0,2,2.1},{"Yes","Maybe","No"})
B2:B4	B2	=IF(D2<=2,IF(D2<2,"Yes","Maybe"),"No")
C2:C4	C2	=IFS(D2<2,"Yes",D2=2,"Maybe",D2>2,"No")

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C	D
1	Team Names	Results	Sector	Values based on Sector
2	Product Team	Yes	223	0
3	Customization Team	Maybe	224	2
4	Product Team	No	226	3
Sheet6

Cell Formulas
Range	Formula
B2:B4	B2	=CHOOSE(SIGN(D2-2)+2,"Yes","Maybe","No")