Hey all,
I've got a lookup question for you. I've got a table with a set of options and their corresponding data points. I want a formula outside of the table to return one of these data points based on a series of toggles that the user can manipulate. I've gotten 2/3 of the way there by using a sumifs formula, but I'm not sure how to take in to account the third lookup criteria - namely if the size entered by the user is between or over a certain threshold.
The spreadsheet does a pretty good job of explaining what I'm after.
Thanks for your time.
Bookmarks