[SOLVED] Formula for looking up cost

[jackson_hollon]

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

[Kaper]

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[Vikas_Gautam]

Here is another alternative.
Non CSE one.

Please Login or Register  to view this content.

Put this in D2 and drop down.

[jackson_hollon]

Kaper,

Thank you. This is exactly what I want. Thanks.

Jackson

[jackson_hollon]

Vikas_Gautam,

Thank you for the reply. Your formula works as well.

Thanks a again.

Jackson