View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
 
Posts: 63
Default 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