Cross reference cell value against the column name?
Is there a formula or function that will lookup a value in another column (same row) and check against the column name?
I have a Cell with a start date from a new employee. I then calculate a date of when that employee will be fully trained (Ramped). I need to then indicate that this new employee is capable of contributing as a Ramped Resource by setting the cell under the column with the corresponding date in the "Full Ramp....." date?
Help Article Resources
Check out the Formula Handbook template!