Search and return multiple results.

Can someone help me find the right formula?

I would like to find a value in another tab and return different results.

It concerns the following:

In the 'Tab' tab, the search value is in column A. I would like to see all matching values from column A ('Search' tab) in column B ('Tab' tab), by searching the matrix B2:O11.

For example, if I search for the value "5.1", I expect the result in cell B3 (tab 'Tab').
Code of Conduct
Policy - Compliance
Guideline - Risk Strategy
Guideline - Risk Management
Guideline - Information Protection
Guideline - Data Privacy Protection
Guideline - Identity and Access Management

Next comes cell B4 the result.
""


The result will then appear in cell B5.
Guideline - Identity and Access Management

Scherm?afbeelding 2023-03-31 om 22.43.34.pngScherm?afbeelding 2023-03-31 om 22.43.30.png


What I have already found or tried
X.LOOKUP = returns only 1 result (the first or the last)
Pivot table = this is manual work

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

It takes a while to find your way around!!

Delete all expected results. Use this. The results spill down.

Formula:

Please Login or Register  to view this content.

just 'tweak' your macro - in column 'A' select your search object (making it the active cell) - press orange button to run macro - if item present appears in relative rows in column 'B'

Mxmaarten welcome to the forum.

I the problem turns out to be the MAP function you may need to run an Office 365 update. If you are not familiar with how to do this it is under File>>More>>Account. An Update Options button will be about halfway down the right hand pane.