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