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!
In B2 copied down:
=IF(VLOOKUP(A2,Sheet1!$A$2:$C$18,3,0)="Y","",VLOOKUP(A2,Sheet1!$A$2:$B$18,2,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Doesn't work
Function gives blanks only. I checked all spaces and typos.
Have you tried to drag B2 down? (copy and paste downward)
Quang PT
Well, it does - on the sample you provided.Originally Posted by LinaVa
Doesn't work
sorry, it does work. missed the $ signs in original file
Thank you very much. This is extremely helpful.
No problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks