# Formula to check expirations

1. ## Formula to check expirations

I have a direct mail company and lock in certain areas for a certain amount of time for my clients.

I want to be able to check a hand full of zip codes to see if they are aviable for new clients.

The lock in period is 60 days.

For a zipcode to be available it can not be in my list or has passed the 60 day expiration.

Attached file.

Thanks!

2. ## Re: Formula to check expirations

Forgot to add file. Here it is.

Thanks for the help

3. ## Re: Formula to check expirations

=INDEX(A2:G46,MATCH(I4,B2:B46),7)

will find the zip code and return if it is available

=MAX(INDEX(A2:G46,MATCH(I4,B2:B46),5),INDEX(A2:G46,MATCH(I4,B2:B46),6))

will find the available date, which will either be today or the expiry day!

4. ## Re: Formula to check expirations

Thank you very much! I wish I could contribute here, but I know zero about Excel.

5. ## Re: Formula to check expirations

Still having a little bit of trouble with this. When I enter a zipcode that is not in the list, it returns a NO and the expiration date of the zip code nearest to the value that I enter. I've tried using different cell formats, but the results are the same. It appears at first glance to function properly, but if the zip code is not listed it will not function properly.

Any help would be appreciated.

6. ## Re: Formula to check expirations

Someone help my brain hurts!

7. ## Re: Formula to check expirations

Any suggestions?

Thanks!!

8. ## Re: Formula to check expirations

Is this the impossible formula?

9. ## Re: Formula to check expirations

i think ist is in j4
and since you only need to find the first instance of yes (you have already done the 60day calc in col g anyway)
in K4
=iferror(INDEX(\$B\$2:\$B\$46,MATCH("yes",\$G\$2:\$G\$46,0),0),"none free")

10. ## Re: Formula to check expirations

Thank you very much! I will give this a try.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1