Help with function in a financial calendar

[saraunger]

I am working on a financial calendar that will match a specified number with values in a column, then input subsequent values in a separate column.

I used the IF function =IF(Q11:Q17=1,R11:R17,"") and it worked for one cell, but not the rest.

Attached is a picture and the spreadsheet.

Budget Calendar Spreadsheet - editable

Please help! I've been working on this for hours, but it's been a while since I worked with functions, so...

I want all the cells to work like the day on Friday the 1st. I'm not even worried about the balances yet.

 

[Fluff]

How about

=IFNA(INDEX(P11:P45,MATCH(1,Q11:Q45,0)),"")

 

[mikerickson]

You need to write the formula for one cell and drag it to the other
=IF(Q11=1,R11,"") and drag it down.

 

[Fluff]

Another option so you don't need to change the formula each month

=IFERROR(INDEX(P11:P45,MATCH(DAY(K10),Q11:Q45,0)),"")

 

[saraunger]

Another option so you don't need to change the formula each month

=IFERROR(INDEX(P11:P45,MATCH(DAY(K10),Q11:Q45,0)),"")

YOU ARE A LIFESAVER! You just saved my weekend. Thank you!!!

 

[Fluff]

Glad we could help & thanks for the feedback.