Forum Discussion
Using Data in one field to fill check boxes or add yes or no into other fields.
If you have a reference table (i.e. a table with the 12 positions along the first column and the Yes/No responses in each of the following columns) you can use the vloolup function to do this. I have made a sample sheet that you can use as a reference.
If you have a reference table (i.e. a table with the 12 positions along the first column and the Yes/No responses in each of the following columns) you can use the vloolup function to do this. I have made a sample sheet that you can use as a reference.
could these be put on separate sheets? the reference and the actual data about the employee.
The goal is to have the Manager at a location in our enterprise go to a web site enter the name, number, location, and position of the new employee and then use the position abbreviation as the reference value. For us in IT we would want to see all that information, plus what hardware they need and what applications they need to be setup in. So what if sheet 2 had the references and sheet 1 called them?
what would that look like with Vlookup?