G
Guest
Am trying to create a fomulae that will look up data dependant on rows and
columns. E.g In the lookup range cells A1:A10 contains diffrent item codes
and columns B11 contains months i.e Jan-05, April-05, Aug-05 (being
datevalue labels). Cells B210 contain the data dependant e.g rates.
On the output sheet which contains item codes (A1:A10) and B1:M1 the months
of the year (Jan to Dec-05). For cells B1:M10 it should be pick rates for the
months that are less or equal to the column month (B1:M1) and itemcode as per
column A.
columns. E.g In the lookup range cells A1:A10 contains diffrent item codes
and columns B11 contains months i.e Jan-05, April-05, Aug-05 (being
datevalue labels). Cells B210 contain the data dependant e.g rates.
On the output sheet which contains item codes (A1:A10) and B1:M1 the months
of the year (Jan to Dec-05). For cells B1:M10 it should be pick rates for the
months that are less or equal to the column month (B1:M1) and itemcode as per
column A.