Trying to IF on another Sheet using multiple variables - Excel 2013

**pterodactylptime** · 02-02-2014, 01:00 AM

Hi all!

So this is my first post on Excel Forum. Up until now, I've been able to guess and Google my way through most of my Excel problems. Excel 2013 with this current workbook seems to be a little tricky, so hopefully one of you gurus can help.

Note: See attachment for reference

Problem:
The sheet called February2014 has a list of bills to be paid. I am trying to get them graphically represented on the sheet called Calendar.

Desired output:
#1
A9 (in February2014) has Savings listed. I would like for it show on the Calendar sheet in the 15th of the month highlighted in green since there is a check mark in the Cleared? column. (Example: Savings-Paid)

#2
A13 (in February2014) has Water/Sewage listed. I would like for it to show on the Calendar sheet in the 17th of the month highlighted in red since there is no check mark in the Cleared? column and it is due. (Example: Water/Sewage-Due)

Test.xlsx

**windy58** · 02-02-2014, 07:39 AM

How are the details being put into the calendar?

**RobertMika** · 02-02-2014, 10:33 AM

You have another table for paycheck on 25th.
What about those data?
You have got as well multiple instances of the same data(let say 11 and 15)
What if one is paid and one not.
What if one is in the left table and the second in the second?