On Nov 2, 10:18*am, joeu2004 wrote:
On Nov 2, 7:47*am, Ymtrader wrote:

a1:1410 b1:1416 c1:1421 d1:1423 e1:1436 f1:1437 g1:1439 h1:1445
i1:1450 - *So a number that falls between the 2 adjecent numbers will
define the zone. *ie a number of 1415 would be in zone 1 a number of
1448 would be in zone 8. * Zone 1 would be greater or equal to 1410
but less than 1416 * Zone 2 would be greater or equal to 1416 but less
than 1421 ect.

=MATCH(A2,A1:I1)

gives the zone number. *If you want text:

="ZN" & MATCH(A2:A1:I1)

PS: *For broader participation, you might want to post future
inquiries using the MS Answers Forums athttp://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum. *It's just that MS has ceased to
support the Usenet newsgroups. *Hence, participation here is limited
to the sites that share a common newsgroup mirror, which is no longer
centralized at MS.

Thank you all for your help, I will try each of the suggestions.
Again thank you!