Forum Discussion
If Columns Contain Matching Values, Then Return Text.
I'm looking for a way to streamline the training entry process, and need a bit of help with a function.
I have an established spreadsheet with first and last names of employees, along with columns for specific training. When that training is completed, the date of completion is manually entered into the cell of the corresponding person's row.
The goal is to reference a second sheet (training attendance sheet) and compare first and last names against those in the existing sheet. If the names of those in attendance match those of the master spreadsheet, a date of completion will be automatically placed (text format).
Thanks in advance.
5 Replies
- I think an index Match formula would work for you.
However the 2nd sheet would that always be a different sheet and the date of completion would that be on the training attendance sheet ?- I looked into using an index match, but kept getting errors. Having issues somewhere in the formula. The second sheet would always be a different sheet and the date of completion would be included on it, so I guess I could reference that date rather than manually entering one in text format.
Its hard without seeing the files but are the first and last name combined or two different cells?
