Try...

=IF(D35<=110%,VLOOKUP('TNT'!O4,IF(D35<=105%,'setf-lease'!$W$5:$AE$24,'set
f-lease'!$W$27:$AE$46),MATCH(D25,IF(D35<=105%,'setf-lease'!$W$5:$AE$5,'se
tf-lease'!$W$27:$AE$27),0),0),"Exceeds Guidelines")

Hope this helps!

In article ,
sharkfoot
wrote:

How do I write an if formula that does the following:


If D35 is between 0% and 105.00% then return the value of this
formula:
=INDEX('setf-lease'!$W$5:$AE$24,
MATCH('TNT'!O4,'setf-lease'!$W$5:$W$24,),
MATCH(D25,'setf-lease'!$W$5:$AE$5,))

If D35 is between 105.01% and 110.00% then return the value of this
formula:
=INDEX('setf-lease'!$W$27:$AE$46,
MATCH('TNT'!O4,'setf-lease'!$W$27:$W$46,),
MATCH(D25,'setf-lease'!$W$27:$AE$27,))

If D35 is greater than 110.00% then return the value "Exceeds
Guidlines"

So I'm trying to combine more than one formula and do not know how to
do that. Can anyone assist? Thanks!