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

@Shanekr1 

 

Hi there,

Please mention attached file.

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

Thank you Iigar
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
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.

Fantastic thank you