formule di numbers - formulas of numbers

è possibile collegare ad ogni elemento di un menu a scomparsa un valore percentuale in un'altra cella? in maniera tale che si possa vedere lo stato di avanzamento del lavoro in percentuale in base alla voce nel menu a scomparsa selezionata.

Is it possible to link to each element of a pop-up menu a percentage value in another cell? so that you can see the progress of the job as a percentage based on the item in the pop-up menu selected.

MacBook Air 13″, macOS 12.1

Posted on May 15, 2022 4:21 AM

Reply
Question marked as Top-ranking reply

Posted on May 15, 2022 8:11 AM

Yes, you can do something like this:




=XLOOKUP(A2,{"Milestone 1";"Milestone 2";"Milestone 3"},{20%;50%;75%},"Error")


In Italian it would looks something like this:


=CERCAX(A2;{"Milestone 1";"Milestone 2";"Milestone 3"};{20%;50%;75%};"Error")


The cells in column A are Pop-up Menu:




The idea is to have the same number of items in the first set of { } as in the second set of { }.


SG

1 reply
Question marked as Top-ranking reply

May 15, 2022 8:11 AM in response to davidelambri

Yes, you can do something like this:




=XLOOKUP(A2,{"Milestone 1";"Milestone 2";"Milestone 3"},{20%;50%;75%},"Error")


In Italian it would looks something like this:


=CERCAX(A2;{"Milestone 1";"Milestone 2";"Milestone 3"};{20%;50%;75%};"Error")


The cells in column A are Pop-up Menu:




The idea is to have the same number of items in the first set of { } as in the second set of { }.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

formule di numbers - formulas of numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.