I'm attempting to do a multiple offset match formula.
In essence, I have 6 tables
Based on the first "criteria", I need to look in a cell (A1), based on the value of that, I then need to do a offset, match (double lookup), based on the criteria from 2 other cells. However, thus far I've started the formula with an IF statement, then roll into the offset, match.
I know I'm limited to 7 nested IF statement's.The problem I have is one of the values for the match is a decimal (0.387) and I need to round it to 0.4. Currently I"m using the following formula to round (IF(--MID(D44;3;1)>=5;ROUND(D44;2);ROUND(D44;2)). That means I run out of nested IF's

Any advise would be appreciated.

Regards,

Nutzman