Thread: Soooo....
View Single Post
Old 05-16-2007, 09:31 AM   #8963
BarTopDancer
Prepping...
 
BarTopDancer's Avatar
 
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
BarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of cool
Quote:
Originally Posted by Kevy Baby View Post
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")
Good. That goes beyond the scope of my Excel brain.
__________________
Spork is the new MacGyver
BarTopDancer is offline   Submit to Quotes