Lookup a value from two columns

[springran]

Hi please help me

I would like a formula in column B.

Notes: I want to search value in column A from column D & E. if match and return vulue in column F.

 

[SunnyAlv]

like this ?

=XLOOKUP(A2,$D$2:$D$7,$F$2:$F$7,XLOOKUP(A2,$E$2:$E$7,$F$2:$F$7))

 

[Cubist]

One option.

Book1
	A	B	C	D	E	F
1
2	11	A		11	11	A
3	55	C		99	9	B
4	22	C		55	55	C
5	33	#N/A		88	8888	A
6	55	C		66	66	B
7	8888	A		22	22222	C
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=XLOOKUP(TRUE,(A2=$D$2:$D$7)+(A2=$E$2:$E$7)>0,$F$2:$F$7)

 

[springran]

like this ?

=XLOOKUP(A2,$D$2:$D$7,$F$2:$F$7,XLOOKUP(A2,$E$2:$E$7,$F$2:$F$7))

View attachment 112282

Thank you

 

[springran]

One option.

Book1
	A	B	C	D	E	F
1
2	11	A		11	11	A
3	55	C		99	9	B
4	22	C		55	55	C
5	33	#N/A		88	8888	A
6	55	C		66	66	B
7	8888	A		22	22222	C
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=XLOOKUP(TRUE,(A2=$D$2:$D$7)+(A2=$E$2:$E$7)>0,$F$2:$F$7)

Thank you