Dear Alkey,

Is this best way to do find and replace long list numbers ? do you have any other solutions?
Thank you very much. It works now. What does the "0" do?

Is there anyway to take the adjacent column values also?
what i mean is, after vlookup, (right now it puts only the one row which is specified as 2 (in this case))
is there a possibility to take adjacent column 2,3 and 5 as well?
It would great to know solution for such thing.
Thanks again for your time

regards
K


Dear prjt, I have a long list of numbers to be replaced in a long list of sheet which runs for 900 rows. That is why i am looking for quick way to do it.