Reference Formula Help

U

udaccountingclass

I have a workbook with items listed in column a and 12 months referenced inrow 1 starting in column b. The table contains monthly data for each item.. I need help creating a reference formula that will match the item as wellas the month. For example, find the data in the cell where the month of "3/1/15" and the item "forks" intercept. Thank you in advance for the help.

Matt
 
C

Claus Busch

Hi Matt,

Am Thu, 15 Jan 2015 19:00:18 -0800 (PST) schrieb
(e-mail address removed):
I have a workbook with items listed in column a and 12 months referenced in row 1 starting in column b. The table contains monthly data for each item. I need help creating a reference formula that will match the item as well as the month. For example, find the data in the cell where the month of "3/1/15" and the item "forks" intercept. Thank you in advance for the help.

try:
=INDEX(A1:N200,MATCH("forks",A1:A200,0),MATCH(DATEVALUE("03/01/2015"),A1:N1,0))
or
=INDEX(A1:N200,MATCH("forks",A1:A200,0),MATCH(3,MONTH(A1:N1),0))
The last formula is an array formula to insert with CTRL+Shift+Enter


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top