Search multiple values and return multiple results.

[Mxmaarten]

Can someone help me find the right formula?

I would like to find multiple values in another tab and return different results.

It concerns the following:

In the 'blad1' sheet, the search value is B2:Y2. I would like to see all matching values from column A ('blad 2') in column A ('blad1' sheet), by searching the matrix B2:D124.

For example, if I search for the value "5.1", I expect the result in cell A2 (sheet 'blad1').
Information Protection, Data Privacy Protection, Legal and Regulatory Monitoring,

[Limor_OP]

Hi,
The file is empty

[JohnTopley]

Empty "Blad1" ?? !!!

[Mxmaarten]

Sorry. I uploaded now the right one.

[Limor_OP]

And where do you want the results to appear ?
Is it column A?

[Mxmaarten]

Yes!

The result must be in column A of sheet "blad1". I grayed out the column and now it has a formula in it that doesn't work.

[Limor_OP]

ok so that means you are trying to display multiple results in 1 cell....

Try to add 2 more columns , B & C and use this in A:
=IFERROR(FILTER(Blad2!$B$2:$D$124,Blad1!D2=Blad2!$A$2:$A$124),"")

[CARACALLA]

Blad1

A2=IFERROR(TEXTJOIN(" -",TRUE,UNIQUE(FILTER(Blad2!$B$2:$B$124,ISNUMBER(MATCH(Blad2!$A$2:$A$124,Blad1!$B2:$Y2,0))))),"")

Copy down

[Mxmaarten]

Hi CARACALLA,

Thanks for your comment. It's a good start, but unfortunately I still have a problem with the formula you gave. This is because an overflow error occurs when I try to use the formula for cells A3 and A4. This is because cell A2 returns three values. I've tried several solutions, but so far without success. Do you have an idea how I can solve this problem?

I added a new version of the excel file

[CARACALLA]

File attached .

[Mxmaarten]

Hi CARACALLA,

Awesome! I am immensely grateful for your help.