Excel formula

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.



Good luck!

best response confirmed by W-eva (New Contributor)

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

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