You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

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

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.