Please suggest any formulae / functions

T

TGV

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
 
L

Luke M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top