Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address

The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.

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

User profile for user: davidelambri
davidelambri Author
User level: Level 1
4 points

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
User profile for user: SGIII
SGIII
User level: Level 8
35,426 points

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

View in context

Similar questions

1 reply
Question marked as Best reply
User profile for user: SGIII
SGIII
User level: Level 8
35,426 points

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

Reply

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.
Learn more Sign up