Vlookup help needed

alan

check the below link, maybe you could understand it better than me & come up with a solutions for me. thanks

Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions - YouTube

That video is returning one lookup value that is in a string of values. Not what you have. You are looking for multiple lookups from within the string -- opposite of what you are looking for. By the way, what is the matter with the solution provided to you at EF?

I already know ARGK formula, and i didn't like it, i know there is a better way to do it, that why I'm searching the net & ramananhrm formula is too complicated,i thank them for their efforts but that is not what I'm looking for. what you don't know is that in the source file i have more that 20000 values. that what makes there ways is not efficient. let me ask you this i have name in a column & code in another column let say John in A1 & J1 in B1, and you want to combine them in one cell to be shown like this John (B1), how would you do it. I'm asking that because someone send me a vb Formula which work , but i need to move all the 20000 values in source sheet to one cell to be read as John (B1).Thanks

I am confused by your question. Can you post a sample spreadsheet showing the BEFORE and AFTER scenario. With regards to your original question, I do not have a solution for you.

In a10 and a11 you have same name Gurjar

thats a mistake , you can delete one of them, thanks