[SOLVED] Formula for looking up cost

Hello,

I need a formula to look up cost. I have a sales report, I need to add the corresponding cost depending on what month the item is sold. Please see my sample on the column D.

I read a lot about array formulas. I heard that it is better. But I do not know how to use it. Can this be set up using Array formula?

Thanks for the help.

Jackson

In B3 and following you have some dates form future (or may be from Mac?) - format this column as full date (with year) to see it).
but if there were appropriate ones - corresponding to row1 dates, you could use standard formula here:

Formula:

=INDEX($L$2:$W$6,MATCH(C2,$K$2:$K$6,0),MATCH(B2,$L$1:$W$1,0))

if you want to focus just on month (year or day does nor matter), then indeed array formula would do:

Formula:

=INDEX($L$2:$W$6,MATCH(C2,$K$2:$K$6,0),MATCH(MONTH(B2),MONTH($L$1:$W$1),0))

Here is another alternative.
Non CSE one.

Formula:

=INDEX($L$2:$W$6,MATCH(C2,$K$2:$K$6,0),LOOKUP(MONTH(B2),MONTH($L$1:$W$1),COLUMN($L$1:$W$1)-COLUMN($L$1)+1))

Put this in D2 and drop down.