Extend formula automatically to the left (then down)

[clemlcfc]

Hey as you can see in the second page of my excel file, i have a graph.

In A2, the formula is : =IF(Tableau3[[#En-t?tes];[Fruit]]=list!B2;"X";"")

What i would like is to extend to the right automatically (when i press on the button)

My problem is that if i try extending to the right i get this formula : =IF(Tableau3[[#En-t?tes];[Vegetable]]=list!C2;"X";"")
But what is want is C2 to stay B2. and then obviously when i go down the rest of the column, i get B3, B4 and so on.

Any ideas ? Thank you

HELP FORMULA.xlsm

[AliGW]

Anchor the cell reference like this:

list!$B2

[clemlcfc]

thank you for your help

[AliGW]

Glad to have helped.

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[clemlcfc]

i will do. Just a last thing, i know it's possible to fast extend down by double clicking in the right down corner but how can i fast extend to the right ?

[AliGW]

No way that I know of in 2016 without VBA. But that's a different question.

Please mark the thread as solved - the question you asked in the opening post is resolved. Thanks.