Multi Lookup Values in One Cell

[bharath]

Hi,
Here requirement is multi lookup values in one cell and should be dynamic
I attached excel file
ex:
Bharath 1
Bharath 2
Bharath 3
Bharath 4
Bharath 5
Result:
Bharath 1,2,3,4,5,6
Note: Here 'Traspose(Concatenate) 'formula is not suitable for my data, Why because My Data and result's will be different sheets
Thank you.

 

[Somendra Misra]

Hi Bharath,

Please see the attached file (Sheet 3). My solution is partially formula (for getting the unique Vehicle number) and partially VBA ( for getting the DC number).

Copy the formula in column F if you increase your database and press Show DC button to update the results.

Regards,

 

[bharath]

thanks a lot somendra
excellent!
any formula is there to get multi values

 

[Somendra Misra]

Welcome Back anytime.
Will see the posibilty of doing this with formula.

Regards,