First time posting...been working on this for a few days now, hoping someone can help with the below situation; need solution
quickly for meeting on Wednesday...
I have three tables (TenLim, TwentyLim & Excess - each 250+ lines over 6+
columns wide - this can't be changed) that are factoring into one formula dependent on a single number answer between 10-20.
The formula is:
I receive a 'FALSE'
answer on the above formula. I believe it's from the first VLOOKUP situation, due to D7=11 (If D7=10, the formula works). I
thought my first IF statement's false_value was the second IF statement, but it doesn't work. I placed the LOOKUP function
in the second IF statement due to having more than seven responses; is this the problem?
Any info you can pass
along would be greatly appreciated! THANKS!