Lookup multiple items

[kingkong321]

Hi

Is there a lookup formula that will give me multiple items? so in my example attachment i want to look up risk from section A to give me the item in section B, but for risk 7 for example it has multiple items (a,b,c), how would i get all them? even better would be if its possible to have in seperate cells

Hope that makes sense

Thanks

[bebo021999]

Try this array formula in G3:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter
Drag down and across

[kingkong321]

Try this array formula in G3:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter
Drag down and across

Didn't work. Just gave me 'a' for risk 1 2 and 3. I need to be able to get c and d for risk 3.

I copied the formula to g3 and dragged down and across

[bebo021999]

Have you tried to hit Ctrl-shift-enter yet?

[kingkong321]

Ah yes my bad it works now

Much appreciated