# Formula

#### Emma@Work

##### New Member

Sheet one holds info on Direct Debits, AMOUNT/PAYMENT DAY/START DATE/FINISH DATE.
Sheet two is a calendar with days as rows and each month from jan98-dec05 as columns.

I want to show the Payment AMOUNT in the calendar on the payment day withing the range of start date and finish date.

So I can view the calendar and forecast the Direct Debits.

I hope someone can help me,

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
On 2002-08-28 07:42, Emma@Work wrote:

Sheet one holds info on Direct Debits, AMOUNT/PAYMENT DAY/START DATE/FINISH DATE.
Sheet two is a calendar with days as rows and each month from jan98-dec05 as columns.

I want to show the Payment AMOUNT in the calendar on the payment day withing the range of start date and finish date.

So I can view the calendar and forecast the Direct Debits.

I hope someone can help me,

emma,

welcome to the board!

It looks like you'll need some sort of index / match combination for this. But - don't yet have enough info to go on! What happens if there are two payment dates within the range? how have you set up your date values? etc...

Perhaps you could post back with a bit more info on your data. & an example would help no end - what data you've got, what result you'd expect.

Replies
6
Views
303
Replies
1
Views
108
Replies
3
Views
129
Replies
4
Views
350
Replies
1
Views
112

1,219,918
Messages
6,150,954
Members
450,996
Latest member
darko1515s

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back