Looking Up Range of Numbers

J

jackebro

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
 
D

Damon Longworth

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
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
 
Top