2x Lookup Functions + Dropdown List

[ocannon1]

Hi there,

I have a problem which I thought I was adept enough to solve but it looks like i have failed. (Excel sheet attached). I have 5 objects (A,B....,E) and a time series of inflation %s from Jan-2010 to Dec-2017. The data needs to stay in this format because in an unrelated issue it is used elsewhere for calculations. On a separate front page I have a dropdown list where I choose A,B... or E and it gives the user information about the object. I need to include a table of the figures for the correct object that will display the figures in table format. (See sheet).

In cell D18 ive included a formula I thought would work but doenst (returns FALSE rather than a number)). The formula also doesnt yet account for the object chosen in cell D15.

Help?

Thanks - O

[PaulM100]

This should work:

=INDEX($B$2:$CS$6,MATCH($D$15,$A$2:$A$6,0),MATCH(DATE(YEAR(D$17),MONTH($C18),1),$B$1:$CS$1,0))

[ocannon1]

This does work, Thanksss

[PaulM100]

Please mark the thread as Solved if that took care of your problem.