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.