Can someone please help me. And, please don't laugh at my attempted formula below.
What I am trying to do is:
I have a database of all my monthly accounts. I want to be able to make sure that all accounts were reported for that month. I don't want to have to scroll through each account.
I have set up a separate sheet with all accounts on it. So, now I want to
find a value(WCW3936), if it finds this value and the date is 1/1/2006 then say ok,true,something. If not true then say no.
Here is my attempted formuala. Of course, it doesn't work. But, maybe you can see what I'm trying to accomplish.
=VLOOKUP("WCW3936",'Sheet2'!1:65536,12),if('Sheet2'!L:L="1/1/2006",OK,NO)
If I need to explain further let me know. Thank you.
Bookmarks