Hi gang,

I am looking for a way to do a vlookup so just the value of the vlookup is left over in the cell.... and not the formula

i am also looking that the vlookup will take the value in the column in the column G in the sheet (named sheet#) and put that value in next to the right part number the sheet (an infinite number of them)

as you can notice sheet60 column G (vlookup) goes under A sheet61 column G (vlookup) went under B and so on

I want to use the vlookup since the part numbers are not always in the order 1,2,3,4,5 and some part numbers could be added and insterted like a part number 3.5 would go between part 3 and part 4...

i hope that i was clear

the way i would expect on doing it would be using 2 loops one looping though the pages and the other looping though the cells .. but i could be wrong

thanks again for the help in advance!!! here is the example file that goes with this problem

roomie 02-10-2013.xlsx