Hi there,

I've got a sheet 'Clients' where I have client's information. If the client has ended membership, I update his information in Clients sheet and simply remove " A " note after his number and Add the membership ending date , and leave all his information in my database. So the continuing clients have numbers like : 102A

I also have Payment sheet. There I get clients from Clients sheet where there is an " A " in the client number with this formula : 

Please Login or Register  to view this content.
Here in column A I check if the Membership End cloumn is empty or not like this :

Please Login or Register  to view this content.
and in column B , I simply remove the " A " note for a better viewing

Please Login or Register  to view this content.

Well, so far so long everything is good. But I have to have a different workbook for each month. Because the problem I face when I want to have all months in my workbook is :

It is now APRIL. A Client ends his membership in April, and so now he does not have a " A " quote after his number. But in MARTS's sheet , with this formula, he disappears as well. So I lose him on previous months.

The idea is to get all of the clients from Clients sheet, then VLOOKUP their membership end column. If the column is either EMPTY or it's date is SMALLER that the Payment sheet's date, then show it.

I made up this code 

Please Login or Register  to view this content.
On D2 I have that sheet's date.

But this returns all Clients and shows the EX-Clients as FALSE....

Well, I know I made it up a little bit confusing, I hope you get the idea.

Maybe my thinking for the whole client database is wrong.

But I want to see all clients in one sheet, and then have different payment sheets for every month. And all in one work book.

I hope I was clear enough.
Any kind of help is appreciated.
Thanks in advance