Look ups? Kinda............

Ok, here's what I am trying to do.

One tab (Escalations) has months listed in column A and the rates of rent that apply to that month.

On the Run off Tab I have all the months listed in column A from the beginning to the end of the lease.

In column B of the Run off tab, I am trying to find the rental rate for that month from the Escalations Tab.

In column C of the Run off tab, I need to multiply the appropriate rental rate for that month x RSF (Rental Square Feet).

Looking at this on the attachment may help.

Many thanks.

Hi,

Attached is your corrected sheet ...

HTH
Carim

Thanks.

Unfortunately, that VLookup doesn't do what's needed.

I was thinking it would have to be an IF statement. If the month on the run off tab falls between this period on the Escalations tab you would then get this rate. The rates are not consistent and they will change along with the periods.

Please take a look. Thanks.

Hi again,

Sorry but given your escalations Sheet, rate currently changes only in March 2011 ... which is what the vlookup() function does ...copied down to line 63


HTH
Carim

Carim take a look at the new attachment.

I need to get the rate for that month. The rates escalate but they can also be zero. Any thoughts???

Now I am lost ...

The new attachment is identical to previous one ...
Do you mean formula should have been copied all the way down ...

see attachment ...

HTH
Carim

Carim, sorry I lost you there............

I brain farted. You were on point!

Muchas Gracias hermano!

De nada señor ...

Thanks for the feedback

Carim

Anyone see what's wrong in this mess???

=IF(B132<=expire,(VLOOKUP(B132,Escalations!$B$26:$ F$41,5)*RSF),”0”)

Hi again,

Please Login or Register  to view this content.

HTH
Carim

Ok, this works but if I don't want to get false message what could I do???

=IF(B133<=expire,(VLOOKUP(B131,Escalations!$B$26:$F$41,5)*RSF))

Senor Carim, muchas gracias!!!

De nada amigo .. con mucho gusto ...

Thanks for the feedback

Carim