Excel drop down selections x2 with outcome in third box.

[NZ990]

Hi,

I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I would then like a figure to be generated in a 3rd cell (this being the amount of roof batten required) which would be the figure in the single cell where both the selected roof area's row and selected roof pitch's column meet. Any help would be greatly appreciated.

Thanks.

 

[AliGW]

You need to create an INDEX MATCH formula:

=INDEX(array_of_vales(MATCH(top_drop_down,axis_of_lookup_table,0),MATCH(side_drop_down,axis_of_lookup_table,0))

 

[NZ990]

Hi Ali

Thanks for that, I gave it a go but I must not be getting it quite right.

This is what I have currently typed into the 3rd cell that I would like the output to generate in:

=INDEX(J61:O66(MATCH(Z61,SELEC.01,0),MATCH(Z63,SELEC.02,0)))

So the J61:O66 is where I have selected all of the possible outputs in my table that could appear
as an answer depending on my two drop down selections.

Z61 is my 1st drop down selection cell (Roof pitch).

SELEC.01 is where I have selected all of the roof pitches together, along the top of my table.

Z63 is my 2nd drop down selection cell (Roof Area).

SELEC.02 is where I have selected all of the roof area sizes together, down the side of my table.

I then hit enter and get an error message from Excel: "You've entered too few arguments for this function".

What went wrong, what have I missed?

Thanks