Forum Discussion
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 ...
=FILTER($A$2:$A$5,($C$2:$C$5=E2)*($B$2:$B$5=F2))You can try to include both criteria in the FILTER function.
- It worked as well, thank you.
