Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
Allo,
Here's my formula: =IF(Facture!C17="BFG",Facture!H17,0) I have a worksheet named "Facture" which contain field called "Division" from C17 to C51 that have a validation list. Depending of which one I choose (ex. BFG) I want the result of the Field called "Demande" which is next to the one called "Division" such as H17 to show on the next worksheet on the FIRST field. Then if another BFG should appear on the list I want the next one to appear on the next worksheet on the SECOND field and so on. How do I make my formula do it. The formula above work wonderfully but I can't make it recognize that I want the result on the first field and so on. Can anyone help me with this. P.S.: I do not use VBA but rather formulas. Thank you Michelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |