Multiple results from One lookup value

[Manny Singh]

Hi All,

I have described my query in attached sheet.

I would appreciate a formula for this.

Regards,
Manny

 

[Hui]

Manny

I haven't had time to look at your file but have you read:
https://chandoo.org/wp/2010/11/10/vlookup-second-value/

 

[Manny Singh]

Manny

I haven't had time to look at your file but have you read:
https://chandoo.org/wp/2010/11/10/vlookup-second-value/

Hi Hui,

Thanks for referring the cool trick, but I don't think it helps my query.

 

[GraH - Guido]

Hello Manny Singh, I believe you might use the vlookup formula by Boso_Yip in this tread https://chandoo.org/forum/threads/distributing-data-on-a-matrix.37423/#post-224823
EDIT: uploaded a solution like in referenced tread
some helper columns required

 

[bosco_yip]

Hello Manny Singh, I believe you might use the vlookup formula by Boso_Yip in this tread https://chandoo.org/forum/threads/distributing-data-on-a-matrix.37423/#post-224823
EDIT: uploaded a solution like in referenced tread
some helper columns required

Hi GraH-Guido,

1] Please check with your Vlookup formula used which is different from my one

2] Attached here's my Vlookup formula solution file with one helper

Regards
Bosco

 

[GraH - Guido]

Hi bosco_yip, I see now. Thanks for pointing it out. Not always easy to follow you example "first time right".
BTW, I meant with like "similar", not "exactly the same".

 

[Manny Singh]

Hi bosco_yip, I see now. Thanks for pointing it out. Not always easy to follow you example "first time right".
BTW, I meant with like "similar", not "exactly the same".

Hi Bosco,

Thanks once again for your help, it's such a clever formula which will come handy for long time.