Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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 Best 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 Best 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

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 ID.