Forum Discussion
Solved
How to return a single variable from various variables
Hi, my spreadsheet contains various fields that require various inputs which I am trying to automate. I am only trying to automate certain fields. There are 18 sites and 4 departments and I'm tr...
Thank you for uploading the file.
I have added the formula and I have also made some changes that I think are the ones you were looking to have using the data validation.
Hi ricardojose,
I've uploaded a file so you can see the layout and fields. There are 2 worksheets:
Users are where I would want the values populated.
LOOKUP are the values I would like used used for each office.
What I'm trying to achieve is that, if enter the Site into the user worksheet it pulls through the other fields of data relating to that office from the LOOK-UP worksheet.
Thank you for helping me with this!!!
Best,
Sam
Thank you for uploading the file.
I have added the formula and I have also made some changes that I think are the ones you were looking to have using the data validation.