Display results on drop down cell. Xlookup, count, if

[Xtremos]

I´ve a difficult task for me, maybe someone can help.

I´ve a search for a location and this will have to show all the part numbers on that location on a drop down, I´m using Xlookup (buscarx) in order to get such results, the problem is that I can only get the first result not all 4 (on this example).

 

[Fluff]

Hi & welcome to MrExcel.
You need to use the FILTER function instead.

 

[Xtremos]

Thanks Fluff, that solve my problem, now I´ve a follow up question, because we are all about improvement and problem solving.
I was able to create a FILTER that displays all the parts in a certain location.
I´m using a location map in witch every cell should display the parts in that location in particular. But If I use FILTER the results will overlap one another, or will give me an error.
So I use Data Validation to display a drop down with the list of parts, but I´m using results of the filter function, and what I really want to accomplish is to click on every location of the map and display the drop down with the results.
Thanks for the help!!

 

[Fluff]

As this is a different question, it needs a new thread. Thanks

 

[Xtremos]