It is not clear what you are trying to do, but have a look at the Vlookup
and Match function with the TRUE option. This will work if your range is
sorted.

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
"jackebro" wrote in
message ...

I wish to validate a serial number against a table of transactions of
ranges of serial numbers eg serial number is 73 and ranges are 1-25,
26-50,50-100. What is the best way to do this? thanks


--
jackebro
------------------------------------------------------------------------
jackebro's Profile:
http://www.excelforum.com/member.php...o&userid=29628
View this thread: http://www.excelforum.com/showthread...hreadid=505931