save a created formula Solved

Question

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

DjiDji59430 · Answer

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

DjiDji59430 · Answer

You go to Formulas==>define a name
You give it a name, for example Ma_Recherche
and in the "refers to" field you paste your formula.

Strange, by the way, your formula!
Is it an array formula?
Otherwise, it only looks for A2, and why the whole sheet?
At most, you only need 2 columns.
And as an argument 0 at the end, are you looking for an approximate value?

It should have been:

=VLOOKUP($A2,'VOL CODE'!$A:$B,2,1)

it looks for the exact value of A2 in the second column of the 'VOL CODE' sheet

Best regards

DjiDji59430 · Answer

Re https://www.cjoint.com/c/KABleaYpwqL  are you a novice and you make matrices??  Regards

Save a created formula

3 answers

Windows 11 search bar isn’t working anymore

Message saying that my phone is compromised

Unable to print from my smartphone.

Very slow computer

Unable to download a windows update

Request for connection choice

Ssd advice for photos

How to connect a canon printer to wi-fi?

How to delete groups on a mobile phone

Free is offering a streaming service and four tv channels to its subscribers in october.