Hi all,
I've been breaking my head on creating a formula that calculates the green text in the attached image. I have a reference table that contains data ranges as shown in the orange column in the left table. I also have a database where I would like a formula to show me the category number from the reference table based on the values for Jane (red column) in the database. For example, Jane has value 50 in the database. I then want the formula to go to the reference table and check based on the range (orange column; 0-69.1 / 69.1-160.5 / >160.5) in what category value 50 falls (in this case 1 as the range data specifies the upper limit). Same for Iris where value 0.1 matches reference range 0.1 and then for the formula to show me category 1. Does anyone know how to do this using an excel formula?!
Thanks a lot!
Bookmarks