How to Extract all Data of Same Repeated Lookup Value Using XLookUp (No VlookUp)

[ajesh27]

I have the below data set

when i select the Department

I want to get a table wih all the employes working in thhat department like this

Only Vlookup formula can be used to obatain the result table. Kindly advise. Thanks for the Help in advance

 

[kanadaaa]

Use AutoFilter. See Filter data in a range or table.
(Note: If you want the table to be filtered by a cell value, you'd need a code, I think. Maybe it can also be achieved by a formula, but I'm not sure.)

 

[ajesh27]

Use AutoFilter. See Filter data in a range or table.
(Note: If you want the table to be filtered by a cell value, you'd need a code, I think. Maybe it can also be achieved by a formula, but I'm not sure.)

I don't think you understand the question. I know we can use filter,but that isnot the requirement

 

[Fluff]

The best way would be to use the Filter function. https://exceljet.net/excel-functions/excel-filter-function

 

[ajesh27]

The best way would be to use the Filter function. How to use the Excel FILTER function | Exceljet

Yes, I have seen it before. But is there a solution using XlookUp.

 

[Fluff]

Xlookup is not the correct function for what you are trying to do.

 

[ajesh27]

The best way would be to use the Filter function. How to use the Excel FILTER function | Exceljet

Thanks for the Solution. But is there any way with Xlookup

 

[Fluff]

I have already answered that.