Multiple lookup on excel

[mujawarwasim]

I have an excel sheet which has IT goals on the left and multiple metrics to measure the performance for each goal. I am looking for a formula such that if I select IT Goal 1 and the column on the right must show all the relevant metrics (in different rows).

I have attached the excel sheet.

Thank you in advance

[dilipandey]

Hi mujawarwasim,

welcome to the forum.

Try using below formula which need to be entered with key combination: ctrl shift enter :-

Please Login or Register  to view this content.

IT goals.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[Pepe Le Mokko]

using merged rows/columns is to be avoided at all costs - nothing but trouble