Excel formula

[W-eva]

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.

[#2]

Hi @W-eva 

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

Good luck!

[#3 · Accepted 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... 

[#4]

Thank you so much!

[#5]

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