@ Sixthsense…..You already have my Star on this post. I use vlookup very often in various columns and believe me till date i was typing the formula in the first row and then copy it to other columns and then manually change the column number for all the columns.... then copy and paste it all the way down in required columns……Thanks again/VKS