Hi All,

i need a help to make a vlookup function which looks for a value
between 2 values. the calsse are defined in sheet 1 and the value in
Sheet 2. for examlpe in sheet 2 i want the class to have value C becuse
it's total is between 1001 and 1500.

sorry for the bad languge and i hope it is understode.


Sheet 1
------------

Class min max
A 0 500
B 501 1000
C 1001 1500
D 1501 2000
E 2001 2500

Sheet 2
------------
Total Class
1267 X
2209 X
1109 X
1063 X
1112 X
838 X