Looking for If Formula

[spycein]

Hello Everyone,
I have the following table

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]No. of Days[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am looking for a formula in "Column B" which would return the value as per below condition.

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Count Of Days[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much in advance.

Best Regards,
Shib

 

[AlanY]

in B2

=LOOKUP(A2,{0;4;8;12},{0;1;2;3})