View original (French)

Save a created formula

Solved
hub97436 Posted messages 4 Status Member -  
DjiDji59430 Posted messages 4280 Registration date   Status Member Last intervention   -
Hello and best wishes to everyone

Is it possible to save or record a formula that you created
in the formula toolbar (where the formula themes are located)?

Thank you in advance

3 answers

  1.
    DjiDji59430 Posted messages 4280 Registration date   Status Member Last intervention   718
     
    Hello everyone,

    yes, you name it
    Formulas==>define a name and you can call it throughout your workbook

    Best regards
    0
    1. hub97436 Posted messages 4 Status Member
       
      Thank you DIJDIJ
      I would like to put it in the "formulas" tab so I don't have to rewrite it every time =VLOOKUP(A2:A26,'VOL CODE'!1:1048576,2,FALSE)
      can you give me the step-by-step procedure
      thank you
      0