Needing Formula for Table IF AND OR DATE

[fatcookie]

I am having an issue with writing the formula for the following.

IF A equals a certain DATE of the year (for example the 1st of every month) then B is "JACK" AND IF B is "JACK" then C= 80.00

1st - Jack = 80.00
2nd - Tammy = 20.00
3rd - Lisa = 60.00
4th - Laurie = 500.00
5th - Christina = 100.00

This would have to be for the entire worksheet so anytime a date is entered B is automatically "name" (depending on date) then C is automatically the amount.

Hope that makes sense.

A	B	C
Date	Name	amount
01/01/2013	Jack	80.00
01/02/2013	Tammy	20.00
01/03/2013	Lisa	60.00
01/04/2013
01/05/2013
02/01/2013	Jack	80.00
02/02/2013	Tammy	20.0
02/03/2013	Lisa	60.00
02/04/2013	Christina	100.00
02/05/2013
03/01/2013	Jack	80.00
03/02/2013	Tammy	20.00
03/03/2013	Lisa	60.00
03/04/2013
03/05/2013
06/10/2013	Laurie	500.00
02/02/2014
02/03/2014
02/04/2014
02/05/2014
03/01/2014	Jack	80.00
03/02/2014	Tammy	20.00
03/03/2014	Lisa	60.00
03/04/2014	Christina	100.00
03/05/2014

<tbody>
</tbody>

 

[bbott]

Welcome to the board.

You'll need two different formulas; one for column B and one for column C. Enter these in B2 and C2 respectively and copy down:

=IFERROR(CHOOSE(DAY(A2),"Jack","Tammy","Lisa","Laurie","Christina"),"")

=IFERROR(CHOOSE(DAY(A2),80,20,60,500,100),"")

 

[fatcookie]

Welcome to the board.

You'll need two different formulas; one for column B and one for column C. Enter these in B2 and C2 respectively and copy down:

=IFERROR(CHOOSE(DAY(A2),"Jack","Tammy","Lisa","Laurie","Christina"),"")

=IFERROR(CHOOSE(DAY(A2),80,20,60,500,100),"")

The names are not also in order. For example Jack may be the 11/01/2014, 12/01/2014, 01/01/2015...etc and Tammy is 11/15/2014, 12/15/2014, 01/15/2015....They will be on the same day of the month. So its not 1 through 5 but really 1-30/31 (days of the month). Am i making it more confusing? I also have Mary that needs to be once every week.

Basically i have the days listed and i have certain names that need to go on a specific day every month and if it that day and that person then it will be a certain amount every time. Someone will be a monthly person and others will be a weekly thing...like every Monday .

Thanks for taking the time with me!

11/1/2014

11/2/2014

11/3/2014

11/4/2014

11/5/2014

11/6/2014

11/7/2014

11/8/2014

11/9/2014

11/10/2014

11/11/2014

11/12/2014

11/13/2014

11/14/2014

11/15/2014

11/16/2014

11/17/2014

11/18/2014

11/19/2014

11/20/2014

11/21/2014

11/22/2014

11/23/2014

11/24/2014

11/25/2014

<colgroup><col></colgroup><tbody>
</tbody>

 

[bbott]

So do you have a table with 31 days and who would be assigned to which day?

 

[fatcookie]

I have a table with January through December (365 days). I have a list of names and amounts that go with a specific day each month. What i don't know how to do is a formula to auto fill a persons name and amount to a specific date each month or manually enter the information each year.

 

[bbott]

Can you post a small sample of your table?

 

[fatcookie]

12/28/2013				8500.00
12/29/2013				8500.00
12/30/2013				8500.00
12/31/2013				8500.00
1/1/2014	Ben	698.00		7802.00
1/2/2014				7802.00
1/3/2014	TRANSFER		8374.00	16176.00
1/4/2014	Jack	1000.00		15176.00
1/5/2014	Tammy	1000.00		14176.00
1/6/2014	Laurie	1000.00		13176.00
1/7/2014	Jackie	500.00		12676.00
1/8/2014	Carrie	500.00		12176.00
1/9/2014	Christina	500.00		11676.00
1/10/2014	TRANSFER		500.00	12176.00
1/11/2014				12176.00
1/12/2014				12176.00
1/13/2014	Mond	200.00		11976.00
1/14/2014	Charlie	200.00		11776.00
1/15/2014	Tabitha	200.00		11576.00
1/16/2014				11576.00
1/17/2014	TRANSFER		5412.00	16988.00
1/18/2014				16988.00
1/19/2014				16988.00
1/20/2014	Betty	658.00		16330.00
1/21/2014				16330.00
1/22/2014				16330.00
1/23/2014				16330.00
1/24/2014	TRANSFER		491.00	16821.00
1/25/2014	Brian	350.00		16471.00
1/26/2014	Casey	1250.00		15221.00
1/27/2014				15221.00
1/28/2014				15221.00
1/29/2014				15221.00
1/30/2014				15221.00
1/31/2014	TRANSFER		1483.00	16704.00
2/1/2014	Ben	698.00		16006.00
2/2/2014				16006.00
2/3/2014				16006.00
2/4/2014	Jack	1000.00		15006.00
2/5/2014	Tammy	1000.00		14006.00
2/6/2014	Laurie	1000.00		13006.00
2/7/2014	Jackie	500.00		12506.00
2/7/2014	TRANSFER		5081.00	17587.00
2/8/2014	Carrie	500.00		12006.00
2/9/2014	Christina	500.00		11506.00
2/10/2014				11506.00
2/11/2014				11506.00
2/12/2014				11506.00
2/13/2014	Mond	200.00		11306.00
2/14/2014	Charlie	200.00		11106.00
2/14/2014	TRANSFER		1608.15	12914.15
2/15/2014	Tabitha	200.00		12714.15
2/16/2014				12714.15
2/17/2014				12714.15
2/18/2014				12714.15
2/19/2014				12714.15
2/20/2014	Betty	658.00		12056.15
2/21/2014	TRANSFER		491.00	12547.15
2/22/2014				12547.15
2/23/2014				12547.15
2/24/2014				12547.15
2/25/2014				12547.15
2/26/2014	Brian	350.00		12197.15
2/27/2014	Casey	1250.00		10947.15
2/28/2014	TRANSFER		8500.00	19447.15
3/1/2014	Ben	698.00		18749.15
3/2/2014				18749.15
3/3/2014				18749.15
3/4/2014	Jack	1000.00		17749.15
3/5/2014	Tammy	1000.00		16749.15
3/6/2014	Laurie	1000.00		15749.15
3/7/2014	Jackie	500.00	500.00	15749.15
3/8/2014	Carrie	500.00		15249.15
3/9/2014	Christina			15249.15
3/10/2014				15249.15
3/11/2014				15249.15
3/12/2014				15249.15
3/13/2014	Mond	200.00		15049.15
3/14/2014	TRANSFER		500.00	15549.15

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

The people will almost always have the same amount one the same day per month. The TRANSFER is a weekly transaction every Friday.

 

[fatcookie]

Can you post a small sample of your table?

have i lost ya?