A
Alton B. Wilson
Hello all,
I have a "data table" in one Excel file (call it DATA, the table is
sorted on a field called 'CODE') and a second Excel file (call it
FORMULA). I need to lookup information from the DATA table and return
it to the FORMULA file, this will be done by matching a Raw Material
Code number from the FORMULA file to the DATA table. When the code is
matched, I would like to return 5 consecutive cells (in 5 consecutive
columns) of data to the FORMULA file. Currently, I am using 5 vLookup
functions to do this in the 5 consecutive cells. I am doing this to try
to speed up the process.
I think this can be done, but I have never used arrays of data or
functions.
Data Table
CODE Size Cost1 Cost2 Weight Color
100 23 2 13 50 Blue
200 45 5 88 60 Green
300 67 8 74 70 Yellow
400 88 9 99 80 Black
500 98 11 66 90 White
Formula File
CODE Size Cost1 Cost2 Weight Color
Thanks for any help.
Regards,
-- Alton
I have a "data table" in one Excel file (call it DATA, the table is
sorted on a field called 'CODE') and a second Excel file (call it
FORMULA). I need to lookup information from the DATA table and return
it to the FORMULA file, this will be done by matching a Raw Material
Code number from the FORMULA file to the DATA table. When the code is
matched, I would like to return 5 consecutive cells (in 5 consecutive
columns) of data to the FORMULA file. Currently, I am using 5 vLookup
functions to do this in the 5 consecutive cells. I am doing this to try
to speed up the process.
I think this can be done, but I have never used arrays of data or
functions.
Data Table
CODE Size Cost1 Cost2 Weight Color
100 23 2 13 50 Blue
200 45 5 88 60 Green
300 67 8 74 70 Yellow
400 88 9 99 80 Black
500 98 11 66 90 White
Formula File
CODE Size Cost1 Cost2 Weight Color
Thanks for any help.
Regards,
-- Alton