Auto filling a cell based on the entry in another cell
We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name?
I dont want this on the form just on my sheet when the entry has been submitted.
Sorry i am really struggling with this and fear it is around Vlook up which i am also struggling with.
any help would be gratefully received