XLOOKUP with 2 Conditions

[ionelz]

Hi,

I have this formula

=XLOOKUP($B5#,D5:D100,F5:F100) AND IS WORKING

I need to add ONE MORE CONDITION , M5:M100=A$1

THANK YOU

 

[Dermot]

Try this
It first filters the data to apply the condition on M, then uses XLOOKUP on that filtered subset

=LET(data,FILTER(D5:M100,M5:M100=A1),XLOOKUP(B5#,INDEX(data,,1),INDEX(data,,3)))

 

[Peter_SSs]

You could also revert to VLOOKUP for that to save specifying the two ranges separately.

=VLOOKUP(B5#,FILTER(D5:F100,M5:M100=A1),3,0)

 

[ionelz]

Thank you both, formula works

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.