Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
index & match month
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 - |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
index & match month
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) ) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Charp" wrote: 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
Match Month in Date With Month in Header | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions |