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

 

[Joe4]

Other options include:
- You could use the old Advanced Filter functionality, to filter the data to another sheet, as shown here: Excel Advanced Filter – how to create and use
- You could use VBA to move the data.

 

[YansaneYansane]

Looks like I'll have install Microsoft 365....

Great tip

 

[Joe4]

Looks like I'll have install Microsoft 365....

Great tip

If possible, that would probably be the easiest way.
Otherwise, you could use one of the other two options I mentioned in my last post.