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.