Cross reference cell value against the column name?

Eyemalive

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?

Darren Mullen

@Eyemalive Unfortunately no. You would have to write a unique formula for each column to check if it matches the "FULL RAMP..." date.

Alternatively, you could put the dates in the first row in the sheet, lock it so most users can't change it, and accomplish what you want to do, but that may or may not work for your case since the first row would be analogous to a "header row" that you may want to filter out for display purposes