when there are common refrence appearing in different cells in same column
for which we are using lookup function then it picks only the first value
from the reference sheet, is there any solution for this?

Thanks for your help