Thread: Soooo....
View Single Post
Old 05-16-2007, 09:25 AM   #8962
Kevy Baby
Chowder Head
 
Kevy Baby's Avatar
 
Join Date: Jan 2005
Location: Yes
Posts: 18,500
Kevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of cool
Quote:
Originally Posted by BarTopDancer View Post
Did you get your Excel question answered?
Yes. Basically, we were trying to confirm that one list of Zip Codes was a subset of another list. We found a formula that did a lot more than we needed, but it got the job done:

=IF(ISNUMBER(MATCH(Q2,$J$1:$J$7000,0)),MATCH(Q2,$J $1:$J$7000,0),"NONE")
__________________
The thing about quotes on the internet is that you cannot verify their validity.
- Abraham Lincoln
Kevy Baby is offline   Submit to Quotes