I would like to populate a cells with a date that that person is going to present the safety meeting by quarter. The tab is under Names, the information has to come from the 2018 tab. I have tried the IF function, and MATCH but I can't figure it out. I have attached my example spreadsheet. Each person has a number associated with their name, which I thought would make the formula easier to build, but it hasn't. If 1 (henry) has the date left of his name of 1/30/18 I want to put that in 1st Qtr next to henry in the Names tab.
I hope this makes sense.
Thank you.
Bookmarks