SOLVED

Excel Formula issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1898248%22%20slang%3D%22en-US%22%3EExcel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1898248%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20drop%20down%20menu%20in%20cell%20D6%20with%202%20options%20in%20it.%20In%20cell%20B31%20i%20am%20trying%20to%20get%20a%20formula%20that%20will%20copy%20Cell%20B23%20only%20if%201%20of%20the%202%20drop%20down%20option%20is%20picked.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1898248%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1898452%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1898452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872600%22%20target%3D%22_blank%22%3E%40Shanekr1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EPlease%20mention%20attached%20file.%3C%2FP%3E%3CP%3EI%20strongly%20believe%20that%20it%20can%20be%20solution%20for%20your%20request.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1898455%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1898455%22%20slang%3D%22en-US%22%3EThank%20you%20Iigar%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a drop down menu in cell D6 with 2 options in it. In cell B31 i am trying to get a formula that will copy Cell B23 only if 1 of the 2 drop down option is picked.

Can anyone help me please?

5 Replies
Highlighted

@Shanekr1 

 

Hi there,

Please mention attached file.

I strongly believe that it can be solution for your request.

Highlighted
Thank you Iigar
Highlighted
Iigar in your sheet you did for me B31 shows B23 whether Baku or Ganja is picked,
I need B31 to show B23 only if Ganja is Picked.
Could you please redo the formula to accommodate this
Highlighted
Best Response confirmed by Shanekr1 (New Contributor)
Solution

@Shanekr1 

 

Sure. Done and attached.

 

P.S. If you find this solution satisfactory, please mention it as best answer. Thanks.

Highlighted
Fantastic thank you