SOLVED
Home

Formula help/Drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-842354%22%20slang%3D%22en-US%22%3EFormula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842354%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20able%20to%20figure%20out%20this%20formula%20to%20get%20the%20value%20listed%20in%20C3%20(pulling%20from%20a%20separate%20tab)%20but%20I%20am%20trying%20to%20link%20it%20to%20the%20drop%20down%20list%20(where%20it%20says%20Banksville)%20so%20that%20when%20a%20separate%20name%20is%20selected%2C%20the%20value%20changes%20to%20reflect%20the%20correct%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20962px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130586i09017235A3C74F0F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22help.png%22%20title%3D%22help.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20you%20can%20see%2C%20I%20selected%20a%20different%20name%20from%20the%20drop%20down%20but%20the%20formula%20in%20D7%20didn't%20automatically%20update%20like%20I%20need%20it%20to.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20799px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130587i29ED81A060D798F5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22help%202.png%22%20title%3D%22help%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20had%20to%20change%20the%20formula%20to%20say%26nbsp%3B%3DHLOOKUP('with%20dollar%20amount%20pick%20'!DO2%2C'with%20dollar%20amount%20pick%20'!B2%3AGS30%2C2%2CFALSE)%20for%20the%20correct%20value%20to%20populate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20me%20automate%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842354%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842368%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842368%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295182%22%20target%3D%22_blank%22%3E%40ineedhelp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20below%20Index%2FMatch%20function%20to%20auto%20populate%20the%20value%20based%20on%20selection%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DINDEX(Sheet2!%24E%243%3A%24E%2410%2CMATCH(%24C%241%2CSheet2!%24D%243%3A%24D%2410%2C0))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20file%20is%20attached%20for%20your%20reference.%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20it%20works%20for%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842387%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842387%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20perfect.%20As%20a%20follow%20up%2C%20the%20amount%20that%20is%20in%20C4%20(the%20desired%20revenue%20increase)%2C%20when%20a%20number%20is%20manually%20entered%20into%20it%2C%20I%20need%20it%20to%20automatically%20update%20a%20specific%20cell%20in%20a%20separate%20tab.%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20manually%20put%20a%20number%20in%20(say%2030%2C000)%20where%20it%20says%2020%2C000%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20586px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130589iF350D6DD62279A64%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ex1.png%22%20title%3D%22ex1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20have%2030%2C000%20be%20populated%20in%20DP2%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20809px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130590i2D4062F4B3644BDF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ex2.png%22%20title%3D%22ex2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20I%20could%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842390%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295182%22%20target%3D%22_blank%22%3E%40ineedhelp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20answered%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FCreating-a-Form%2Fm-p%2F842054%2Fhighlight%2Ffalse%23M39561%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FCreating-a-Form%2Fm-p%2F842054%2Fhighlight%2Ffalse%23M39561%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842417%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20think%20I've%20got%20it%20figured%20out.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842419%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%2FDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842419%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295182%22%20target%3D%22_blank%22%3E%40ineedhelp%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
ineedhelp
Occasional Contributor

Hello,

 

I've been able to figure out this formula to get the value listed in C3 (pulling from a separate tab) but I am trying to link it to the drop down list (where it says Banksville) so that when a separate name is selected, the value changes to reflect the correct value. 

 

help.png

 

as you can see, I selected a different name from the drop down but the formula in D7 didn't automatically update like I need it to. 

help 2.png

I had to change the formula to say =HLOOKUP('with dollar amount pick '!DO2,'with dollar amount pick '!B2:GS30,2,FALSE) for the correct value to populate.

 

Can someone please help me automate this?

5 Replies
Solution

Hi @ineedhelp 

You can use below Index/Match function to auto populate the value based on selection:

 

=INDEX(Sheet2!$E$3:$E$10,MATCH($C$1,Sheet2!$D$3:$D$10,0))

 

Sample file is attached for your reference.

Please let me know if it works for you

 

Tauqeer

 

 

 

This is perfect. As a follow up, the amount that is in C4 (the desired revenue increase), when a number is manually entered into it, I need it to automatically update a specific cell in a separate tab. For example:

 

I need to be able to manually put a number in (say 30,000) where it says 20,000

ex1.png

 

and have 30,000 be populated in DP2

ex2.png

 

Any ideas how I could do that?

@Sergei Baklan I think I've got it figured out. Thank you!

@ineedhelp , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies