LinkBack URL
About LinkBacks
suniljayanna 
Hi sunijayanna,
Try using below formula:-
=IF(ISERROR(VLOOKUP(A:A,D:E,2,0)=B2),"Missed visit",IF(VLOOKUP(A:A,D:E,2,0)=B2,"Good","Late"))
see attached:- Excel worksheet.xls
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi sunijayanna,
Try using below formula:-
=IF(ISERROR(VLOOKUP(A:A,D:E,2,0)=B2),"Missed visit",IF(VLOOKUP(A:A,D:E,2,0)=B2,"Good","Late"))
see attached:- Excel worksheet.xls
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Thanks DILIPandey! That worked great.
What part of the formula did it calculate that the visit did not occur in the same month?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks