Using XLookup or any ideal function, need to return value from range based on two criteria

[YansaneYansane]

Hello Team,

Need help ....Using XLookup or any ideal function to return matching values over a range, based on a number of criteria ....

In the "Permis de Travail" tab, return value in the yellow area based on cell C2.
Source data => "TABLEAU DE BORD" tab, Columns A thru F.

In the "Long Sejour" tab, return value in the yellow area based on cell C2.
Source data => "TABLEAU DE BORD" tab, Columns A thru F.

Thank You

 

[Cubist]

Try:

=FILTER('Tableau De Bord'!A5:F15,'Tableau De Bord'!C5:C15=C2)

 

[YansaneYansane]

Try:

=FILTER('Tableau De Bord'!A5:F15,'Tableau De Bord'!C5:C15=C2)

I keep getting the attached "Error Message"
Thanks for the help.

Since I'm using the French version of Excel, I've translated the formula to this => =FILTRE('Tableau De Bord'!A5:F1000; 'Tableau De Bord'!C5:C1000 = C2)

 

[Cubist]

I'm not familiar with French settings. See this page if that helps.

Fonction FILTRE - Support Microsoft

Comment utiliser la fonction FILTER dans Excel pour filtrer une plage de données en fonction des critères que vous définissez.

support.microsoft.com

 

[Joe4]

Are you sure you are really using Excel 365, that has the new FILTER (FILTRE) function?

 

[YansaneYansane]

Are you sure you are really using Excel 365, that has the new FILTER (FILTRE) function?

Below is the Version of Excel I'm using...

 

[Cubist]

Edit: What Joe says in #8 below.

 

[Joe4]

Below is the Version of Excel I'm using...

That explains it! You have incorrect information in your profile!

In your profile, you seem to show you are using Excel 365:

But, in the screen print you just posted, it says you are using Excel 2019:

The Filter function is NOT available in Excel 2019. That is why you are seeing that error!

Please update your profile to reflect that you are using Excel 2019 and not Excel 365.
This is what we look at to determine which functions and solutions will work for you!

 

[YansaneYansane]

That explains it! You have incorrect information in your profile!

In your profile, you seem to show you are using Excel 365:
View attachment 119240

But, in the screen print you just posted, it says you are using Excel 2019:
View attachment 119241

The Filter function is NOT available in Excel 2019. That is why you are seeing that error!

Please update your profile to reflect that you are using Excel 2019 and not Excel 365.
This is what we look at to determine which functions and solutions will work for you!

Hi,

Thanks much. I've updated the Windows version so it shows on my Profile..
It seems to disappear from the Excel App when I'm disconnected and does not reset. I will keep an eye on it.

So, is there another function I could use...?

 

[Joe4]

Hmmm, it does not look like you updated it.
Click on this link here: Account details and make the change.
Don’t forget to scroll down & ‘Save’!