Shortcut to select data specified in lists

Hello!

I am wandering if anyone can help provide a shortcut function / equation to select the correct range of data specified by drop down lists.

In the workbook attached ("Data Sheet"), there is unique data for 12 different climate locations across 12 months of the year with 9 different wind turbines, giving the total number of possible iterations to be 1296. From the drop down lists in B1-B3, I want to be able to select any combination of the three variables and present the relevant data in B6-B29. Is there a "clever" way of doing this? I am contemplating writing the longest IF function in history, but from my very limited understanding of MATCH, VLOOKUP and similar functions I believe there may be a way to avoid the early onset of arthritis... I just don't know how to!

If anyone can provide even just a small piece of advice or steer in the right direction, I would really appreciate it.

Thanks in advance,

Calum.

Try this file:

Corrected formula ......

Hi John,

Thanks very much for your help, that corrected formula works perfectly!

Calum

For completeness I have added an ERROR condition as I noted that one of the turbine name did not match your drop-down list. I have also named the input cells A1 to A3 as it might make the formula more understandable and changed the ranges. If you don't want to use names just wrap the IFERROR round the existing formula.

=IFERROR(INDEX($E$1:$FC$250,MATCH(Turbine,$E$1:$E$250,0)+ROW()-4,(MATCH(Location,$E$1:$FC$1,0)+(MATCH(CalMonth,$E$3:$P$3,0)-1))),"error")