Picking 2 dropdown boxes getting a answer

[Victor]

This is what i have so far, on L4 and L5 i have to dropdown boxes. (1 chooses
location, the other the year). I have another chart hidden at the bottom of
the page that has all the numbers i need. i need to show that when you choose
the location and year the "number" (not the location or year) will show in
another cell. What should i put as formula to do this.

 

[L. Howard Kittle]

Hi Victor,

Try this. Adjust to your cells.

=INDEX(B10:F14,MATCH(A1,A10:A14,0),MATCH(B1,B9:F9,0))

Where B10:F14 is the table of info to be returned,(your numbers).
Where Match(A1, is the lookup value of the row,(your location).
Where A1:A14 are the rows holding A1's choices.
Where MATCH(B1, is the lookup valumn of the column,(your Year)
Where B1:F9 are the columns of B1's choices.

HTH
Regards,
Howard