Please bear with my explanation here - I want to be as clear as possible. I have about 8 different tables (different categories), which contain ranges that correspond to point values. I have been using VLOOKUP for each category to calculate the number of points based on which range your input falls into. These are 2 examples of the charts w/lookup.
In another tab, I have an input column, a "points" column, and a drop down list of all 8 categories. Again, each category corresponds to a different VLOOKUP. I am trying to input an amount, and based on which category I select from the drop down, have Excel output the number of points I would earn (I have been trying to do this using VLOOKUP). It works for the first row, since in my final VLOOKUP it checks the first input value - but when I drag down the formula for many rows, it does not update to correspond to the input in that row (it only looks at that first input cell). How can I make it so that the initial vlookup takes the input of whatever row I'm currently in?
This is quite difficult to explain - let me know if any clarification is necessary.