Hi All,
I have a headcount spreadsheet i am working on and i need to compare what HR dates against Finance budgeted Dates.
I have names of contractors in column A and then dates Jan to december in row 1. So i have a name e.g Emma in cell A2 and she is leaving in feb so she would have a minus one (-1) in C2. I have a list of names (say for this case out the way in column X) and i need to lookup the names, in this case Emma, in Column A and return "Febuary" when she is predicted to leave. Also i may have a name without a -1 across the year (they have been extended into 2015-lucky them) and it needs to return "extended to 2015,"
If someone could lead me to the water that would be great !! I am so close just cant quit get there,
Many Thanks
Sasha
Bookmarks