Reference Formula Help
 

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.

Matt

Reference Formula Help
 

Hi Matt,

Am Thu, 15 Jan 2015 19:00:18 -0800 (PST) schrieb
:

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(DATE VALUE("03/01/2015"),A1:N1,0))
or
=INDEX(A1:N200,MATCH("forks",A1:A200,0),MATCH(3,MO NTH(A1:N1),0))
The last formula is an array formula to insert with CTRL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional