IF function returning a value to several cells in a row - Microsoft Community

i trying use if function check date when employee starts work (for financial model) , if dates match, monthly salary returned in each cell remaining months of year. table below shows desired outcome

a	b	c	d	e	f	g	h	i	j	k	l	m
1
2		start	annual	monthly		jul-17	aug-17	sep-17	oct-17	nov-17	dec-17	jan-18
3
4	salary1	aug-17	60,000	5,000		0	5000	5000	5000	5000	5000	5000
5	salary2	oct-17	60,000	5,000					5000	5000	5000	5000
6	salary3	jan-18	60,000	5,000								5000

i tried formula salary1 starting in aug 17

=if(h2=c3),e4,0 - works , returns 5000 in h4. want 5000 returned in i4, j4, k4, l4 , m4 well. there formula achieve this, perhaps replacing e4 {e4:m4} - thanks

@tonytaccone

in g4: =if(g$2 >= $c4, $e4, 0)

then copy right , down necessary

Office / Excel / Windows 8 / Office 2010