SOLVED

Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2478836%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478836%22%20slang%3D%22en-US%22%3EHi%20there%20how%20are%20you%20doing%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20wondering%20if%20you%20could%20do%20me%20a%20favor%20%2C%20I%20just%20need%20to%20know%20if%20there%20is(%20a%20formula)%20that%20i%20cen%20use%20in%20Excel%20so%20when%20i%20change%20the%20%22salesperson%22%20in%20cell%20l3%20the%20values%20in%20column%20L%20change%20as%20well%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20time%20hope%20you%20help%20me%20with%20this.%3CBR%20%2F%3EPlease%20have%20a%20look%20at%20the%20attached%20file%20below.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2478836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2478938%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478938%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1086541%22%20target%3D%22_blank%22%3E%40W-eva%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20this%20is%20possible%2C%20look%20at%20the%20attached%20and%20adjust%20the%20cell%20references%20in%20the%20formulas%20to%20make%20it%20work.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22StoneKiwi_0-1624494982224.png%22%20style%3D%22width%3A%20713px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290840iCEB2B65A01606A59%2Fimage-dimensions%2F713x98%3Fv%3Dv2%22%20width%3D%22713%22%20height%3D%2298%22%20role%3D%22button%22%20title%3D%22StoneKiwi_0-1624494982224.png%22%20alt%3D%22StoneKiwi_0-1624494982224.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2479223%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2479223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1086541%22%20target%3D%22_blank%22%3E%40W-eva%3C%2FA%3E%26nbsp%3BI%20recognise%20the%20schedule%20in%20your%20picture.%20It%20came%20up%20in%20a%20thread%20two%20days%20ago.%20My%20answer%20in%20the%20attached%20link%20has%20it%20all.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel-formula-for-dynamic-drop-down-list%2Fm-p%2F2468968%23M104162%22%20target%3D%22_self%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel-formula-for-dynamic-drop-down-list%2Fm-p%2F2468968%23M104162%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2480455%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2480455%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much!%3C%2FLINGO-BODY%3E
New Contributor
Hi there how are you doing?

I was wondering if you could do me a favor , I just need to know if there is( a formula) that i cen use in Excel so when i change the "salesperson" in cell l3 the values in column L change as well ?

Thank you for your time hope you help me with this.
Please have a look at the attached file below.
4 Replies

Hi @W-eva 

Yes this is possible, look at the attached and adjust the cell references in the formulas to make it work.

StoneKiwi_0-1624494982224.png

 

Good luck!

best response confirmed by W-eva (New Contributor)
Solution

@W-eva I recognise the schedule in your picture. It came up in a thread two days ago. My answer in the attached link has it all.

https://techcommunity.microsoft.com/t5/excel/excel-formula-for-dynamic-drop-down-list/m-p/2468968#M1... 

Thank you so much!
Thank you so so much it worked , i appreciate you and i hope you an amazing day!