Hello!
Log in sheet:IF Column B and H Matches with (MASTER FILE sheet) B and any of the columns dates listed
Instead of "NO" it will be YES
Hello!
Log in sheet:IF Column B and H Matches with (MASTER FILE sheet) B and any of the columns dates listed
Instead of "NO" it will be YES
Last edited by serenitylai; 03-30-2017 at 09:55 PM.
I can't make any sense out of your description while looking at your file.
What sheet are B, H, and K on? Please give an example using specific cells, and also specific cells for where you want YES/NO.
The cells that currently all say NO have no formula. Are you asking for a formula to put in those cells? Or are you asking for an update to your VBA?
I don't see any file but I'm working from an iPad. So here is a general answer...
=IF(AND(B2=H2,B2=K2),"YES","NO")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for helping out!
I used this instedPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks