"Goal: I am trying to write a formula for cell J13 that returns the money value by looking up all the rest of information from the inputs in column J4-J6. For clarity, I want a formula in J13 that takes the 3 values above it to find the $$$ in column D by reference. So J6 = 1000 leading to the top chart section, J4 = A leading to the first 3 rows, J5 = Average leading to D7 which is $50. Or 3000 B Poor leading me to $15 or 5000 A Fair leading to $80. I have been able to get close using if multiple times, but I would like it to run smoothly for the rest of the charts, which add rows and are different sizes than the first chart, If someone could change my tweeking formula in J13, I'd Appreciate it. Thanks
"
Bookmarks