Hello all,
I need to list dates of people that have not yet accepted invitation.
Sheet1 lists names (Column A), date invitation sent (Column B) and "Y" for accepted invitation (Column C).
Sheet2 has matching names (Sheet1 Column A and Sheet2 Column B) and needs sent date input (Sheet1 Column B) IF it was not yet accepted (no "Y" in Column C)
If I use vlookup, it gives me all dates, accepted invitation or not.
Can you pease help me
Thank you!
Bookmarks