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
Bookmarks