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 |
All times are GMT +1. The time now is 06:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com