index & match month

C

Charp

I would like a formula that would match any month I want. IF statements have
a max of 7 criteria and I need more than that.

I would like to enter a month in another spreadsheet and return the data for
that month from the data worksheet.

Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct
LR 87.55 126.77 111.63 174.66 132.49 117.70 135.82 203.85
184.11 177.43
PC 3.91 1.90 6.63 15.33 23.54 126.09 116.21
RE 98.23 29.75 17.27 5.52 10.25 -
SP 92.93 -
 
L

Luke M

Lets say you input type into cell Z1, month into cell Z2 (using same format
as headers). Formula then becomes something like:

=INDEX(B2:J10,MATCH(Z1,A2:A10,0),MATCH(Z2,B1:J1,0))
 

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

Similar Threads

Selecting data from a specific column 1
Return Column match 1
How to avergage colums 7
Find the position of a date 6
weeks in a month 1
how to use if statements or vlookups 0
Month question? 10
Pivot table 3

Top