Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please suggest any formulae / functions
in B3 enter =IF(A$3=$B1, $B2,0)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What would you suggest | Excel Discussion (Misc queries) | |||
Removing all formulae/functions/codes from previously saved worksh | Excel Discussion (Misc queries) | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |