Discussion:
Reference Formula Help
(too old to reply)
u***@gmail.com
2015-01-16 03:00:18 UTC
Permalink
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
Claus Busch
2015-01-16 06:52:03 UTC
Permalink
Hi Matt,

Am Thu, 15 Jan 2015 19:00:18 -0800 (PST) schrieb
Post by u***@gmail.com
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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Loading...