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