Excel Forum

Posted: **Sat Aug 10, 2024 4:15 pm**

Hi there,

I need your input how to lookup a value return multiple outputs.

For example I input 203813 it will populate two accounts...

I attach a template

Note excel 2019

Posted: **Sat Aug 10, 2024 9:29 pm**

..

L9
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($C$9:$C$11816)/($K$9=$C$9:$C$11816),ROWS(L$9:L9))),"")

Copy down a column.

M9
=IFERROR(INDEX(F:F,AGGREGATE(15,6,ROW($C$9:$C$11816)/($K$9=$C$9:$C$11816),ROWS(M$9:M9))),"")

Copy down a column.

Bigcat9Excel

Bangkok Thailand

...

Posted: **Sun Aug 11, 2024 6:48 am**

Thanks .always helpful

Excel Forum

lookup return multiple values

lookup return multiple values

Re: lookup return multiple values

Re: lookup return multiple values