Hello Excel Forums,
I need to compare a value from one table to another table to determine a final value, but the formula needs to identify which range of numbers the first values belongs to.
I had a great formula provided for me for a problem with an extra variable but I'm unable to shorten it without making a mess of it, you can see the original I was provided here.
=INDEX(Result,MATCH(MIN($F2,4),Data_1,0)+MATCH($G2,OFFSET($L$2,MATCH(MIN(F2,4),Data_1,0),0,COUNTIF(Data_1,MIN($F2,4))),1)-1)
I've highlighted the parts of the formula that are relevant to what I still need. I no longer need the part that takes column F into account.
Value to be looked up is on tab 1 column F
Then the values to be used in the sorting are on tab 4, column D.
The result to be returned is found on tab 4, column E
The formula itself needs to be on tab 5, column B
My explanation is probably terrible sorry, hopefully a look at the workbook will make it clear what I'm trying to do.
Bookmarks