Hello. I have a sheet with three columns. Column A is a list of levels (e.g. 1, 2, 3, etc.). Column B shows one value for the levels and Column C shows a second value for the levels:
Lvl Val 1 Val 2
2 9 168
3 10 174
4 10 183
5 11 190
6 11 199
7 12 205
The values are cumulative so that, increasing from level 2 to 4, the total of value 1 would be 29 and the total of value 2 would be 525.
I'd like to have a drop down showing the starting level and another drop down showing the ending level so that, after selecting them, the total of value 1 would be displayed in one cell and the total of value 2 would be displayed in another cell:
Beg Lvl End Lvl V1 V2
2 4 29 525
Is this something that can be easily done?
Thank you for any assistance!
Bookmarks