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 at
http://social.answers.microsoft.com/...ry/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.