Hi All,

I have two sheets. The first one has part numbers down column A, and Qty
accross row 1. There are 12 Qty dates accross row 1, one for each month of
the year.

The second table is 3 columns, column A is part numbers, column B is a
month, and column C is a quantity.

I have many parts with many dates, although there is only one entry for
every possible part-date combination.

What I want is for excel to look at all the data on the second sheet, find a
part number from column A in sheet 1, and return the qty that matches the
date in row1 of sheet 1.