XLOOKUP from a returned value by FILTER

[EK2024]

I have this data returned from FILTER,

D9=UNIQUE(FILTER('Q1 PRD'!$Y:$Y,ISNUMBER(SEARCH(D5,'Q1 PRD'!H:H))))


I was trying to bring item description from a different file for the returned value above using XLOOKUP but it didn't work.

=XLOOKUP(D9,Mapping!$E:$E,Mapping!$F:$F)



Can XLOOKUP read the value from FILTER? If not, is there any tips or tricks?

 

[Kaper]

There shall be no problem with using the content of the cell (does not matter if it is a constant or result of formula).
May be there are some minor differences between data in 'Q1 PRD'!$Y:$Y and Mapping!$E:$E ?
Like extra spaces in front or back, non-breaking spaces (character 160), decimal numbers which are result of computations and look pretty similar, but differ a bit, like 2 and 2.000000000001 (they will be both visible in a cell as 2), Dates, which in one of thiese ranges are excel dates and in the other one are just texts which only look as dates, etc.

Moreover, you probably can do a step forward and use directly:

=XLOOKUP(UNIQUE(FILTER('Q1 PRD'!$Y:$Y,ISNUMBER(SEARCH(D5,'Q1 PRD'!H:H)))),Mapping!$E:$E,Mapping!$F:$F)