Forum Discussion
HaythamOlwan
May 11, 2022Copper Contributor
Is there a way to use FILTER function within XLOOKUP function?
Hi, I am trying to retrieve data from a table based on two variable, so I thought of using FILTER function to limit the options within the Xlookup array to the needed values based on the the second ...
Riny_van_Eekelen
May 11, 2022Platinum Contributor
HaythamOlwan Try this:
=FILTER(A2:A5,(B2:B5=F2)*(C2:C5=E2))