Reference Formula Help

  • Thread starter Thread starter udaccountingclass
  • Start date Start date
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
 
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.
Click to expand...

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.
 
Back
Top