Hi!
I would like to use the attached data (rating and appetite levels) to look at the "tolerance table" and return a result from the table.
Examples given manually in the spreadsheet - so a rating of 9, with an appetite of 4 will give a tolerance level of "leaning high". Imagine I could play around and come up with maybe an IF formula to put into column G, but I really need it to read out of the "tolerance table" and not sure I can do that with an IF formula?
I intend to send this on to someone and I'd like them to be able to update the table and the results change accordingly.
Any thoughts?
Thanks!
Bookmarks