software

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: www.excelforum.com/member.php...oamp;userid=29628
View this thread: www.excelforum.com/showthread...hreadid=505931It 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
quot;jackebroquot; gt; 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:
www.excelforum.com/member.php...oamp;userid=29628
View this thread: www.excelforum.com/showthread...hreadid=505931