Forum Discussion

HaythamOlwan's avatar
HaythamOlwan
Copper Contributor
May 11, 2022

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 ...
excel
Rebaaa's avatar
Rebaaa
Copper Contributor
Dec 02, 2022

HaythamOlwan 

I know it's been awhile and this has already been solved but I came across this and wanted to offer another solution. You can use multiple variables in an xlookup by using an "&". Just make sure your lookup values are in the same order as you lookup array. With the below formula, you get the name George for a male born in 1982.

=Xlookup(E2&F2,C2:C5&B2:B5,A2:A5) 

 

  • Crytetra's avatar
    Crytetra
    Copper Contributor
    Feb 28, 2025

    Hi Rebaaa I know it's been years since you posted this, but this just came in so handy for me after I was scouring the internet for a solution for this issue. I wanted to make sure I properly thanked you for this, you just saved me so much time and additional wasted computations.

Resources