Fill Value from a table

[Hendric]

All,

What best formula can be used to transfer this table below A1:B5 to table C1:O2?
[TABLE="width: 500"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD="align: center"]Month
[/TD]
[TD="align: center"]Cost
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD="align: center"]Jan
[/TD]
[TD="align: center"]100
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD="align: center"]Apr[/TD]
[TD="align: center"]250
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD="align: center"]Jun
[/TD]
[TD="align: center"]200
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD="align: center"]Aug
[/TD]
[TD="align: center"]0
[/TD]
[/TR]
</tbody>[/TABLE]

This result what I am looking for as per table below. When B4 equal zero, B3 value will replace all value until Dec.
If B5 not equal zero, Aug to Dec will be filled by B5.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]J
[/TD]
[TD="align: center"]K
[/TD]
[TD="align: center"]L
[/TD]
[TD="align: center"]M
[/TD]
[TD="align: center"]N
[/TD]
[TD="align: center"]O
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Month
[/TD]
[TD="align: center"]Jan
[/TD]
[TD="align: center"]Feb
[/TD]
[TD="align: center"]Mar
[/TD]
[TD="align: center"]Apr
[/TD]
[TD="align: center"]May
[/TD]
[TD="align: center"]Jun
[/TD]
[TD="align: center"]Jul
[/TD]
[TD="align: center"]Aug
[/TD]
[TD="align: center"]Sep
[/TD]
[TD="align: center"]Oct
[/TD]
[TD="align: center"]Nov
[/TD]
[TD="align: center"]Dec
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Cost
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]250
[/TD]
[TD="align: center"]250
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]200
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much for any feedback.

Regards,

 

[VBA Geek]

something along these lines I assume

Excel 2010
	E
3	100
Sheet1

Cell Formulas
Range	Formula
E3	=IFERROR(1/(1/INDEX($B$2:$B$8,MATCH(E$2,$A$2:$A$8,0))),D3)

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Month	Cost
2	Jan	100		Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
3	Apr	250		Cost	100	100	100	250	250	200	200	200	200	200	160	160
4	Jun	200
5	Aug	0
6	Oct	0
7	Nov	160
8	Dec	0
Sheet1

 

[Hendric]

Hi VBA Geek,

Thank you very much. It works.

Regards,