Hi, I have two tables with multiple criteria that I use index and match to pull the right output. See attached. What I cant' figure out is how to pull the right cell when the units on my table are not individual numbers but groups IE if the user enters 25 in C4 the attached example should know to return C9 in for the output.
My knowledge is limited but I think I need to make some kind of giant nested if statement and build it into my output formula, but that's making my eyes bleed.
Please see the attached and you'll quickly understand my issue. If you type "Up to 75" in C4 you will see the output 1. If you type 25 it doesn't know what to do.
Maybe there is a different way to format my tables that would be better. I'm open to anything.
Thanks
Moderator note: Since you are new to the forum and seem to be struggling with the title change I am going to change it for you this time as a courtesy.
Bookmarks