lsanchez
10-06-2006, 11:42 AM
Someone sent me a workbook with a VLOOKUP and I thought maybe I could do something else with it.
In sheet 1 you would request what is the old number for new# N12 and it would extract the information from sheet 2 with the formula:VLOOKUP(A2,Materialmaster,2,FALSE)
Sheet 1 ------Sheet 2
New#--Old#--New#-- Old#
N12 ----------N12---- 12
--------------N10---- 10
.... ....
Now I have populated other columns in sheets 1 and 2 to to extract more information but the I don't understand the formula and copying it doesn't work.
In sheet 1 you would request what is the old number for new# N12 and it would extract the information from sheet 2 with the formula:VLOOKUP(A2,Materialmaster,2,FALSE)
Sheet 1 ------Sheet 2
New#--Old#--New#-- Old#
N12 ----------N12---- 12
--------------N10---- 10
.... ....
Now I have populated other columns in sheets 1 and 2 to to extract more information but the I don't understand the formula and copying it doesn't work.