Please suggest any formulae / functions
 

A B C D E
1 Jan Feb Mar Apr
2 50 25 17
3 JAN
4 FEB

In b3,c3,d3,e3 i want to enter a formula that should search the a3 cell and
locate the result in b3 or c3 or d3 or e3 if the a3 = b1 or c1 or d1 or e1 at
the same time the result should be produced in the corresponding month column
only
(ie) if a3=feb then the result should produce 0 in b3, d3, e3 but in c3 the
result should be 25.
(ie) if a3=mar then the result should produce 0 in b3, c3, e3 but in d3 the
result should be 17.

I hope i made it clear

Thanks in Advance.

TGV

Please suggest any formulae / functions
 

In B3,
=IF($A3=B$1,B$2,0)

then just copy to the other cells, and you should be good to go.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TGV" wrote:

A B C D E
1 Jan Feb Mar Apr
2 50 25 17
3 JAN
4 FEB

In b3,c3,d3,e3 i want to enter a formula that should search the a3 cell and
locate the result in b3 or c3 or d3 or e3 if the a3 = b1 or c1 or d1 or e1 at
the same time the result should be produced in the corresponding month column
only
(ie) if a3=feb then the result should produce 0 in b3, d3, e3 but in c3 the
result should be 25.
(ie) if a3=mar then the result should produce 0 in b3, c3, e3 but in d3 the
result should be 17.

I hope i made it clear

Thanks in Advance.

TGV

Please suggest any formulae / functions
 

in B3 enter =IF(A$3=$B1, $B2,0)