• 412K Members
• 5,213 Online
• 468K Conversations
SOLVED

## Formula help/Drop down list

Occasional Contributor

# Formula help/Drop down list

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.

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.

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

# Re: Formula help/Drop down list

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

# Re: Formula help/Drop down list

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

and have 30,000 be populated in DP2

Any ideas how I could do that?

# Re: Formula help/Drop down list

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

# Re: Formula help/Drop down list

@ineedhelp , you are welcome

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies