Emelda,
Not sure what you mean by "sliding scale" vs "fixed scale"
but I'll take a guess.
The fourth argument of a vlookup can be set to either True or False.
VLookup("what", "where", "index", T/F)
With the argument set to "True" (sliding scale???), your data table
is assumed to be (and definitely should be) in alphanumeric order.
Example setup:
0 A
100 B
200 C
300 D
etc.
A Vlookup of anything from 200 to anything less than 300
with an index of 2 will return "C" (if the argument is set to True)
With the argument set to False (fixed scale???), your data table
can be in any order and the VLookup will only return an exact match.
Same table as above, a VLookup of 300, index 2 will return a "C"
A VLookup of 222, index 2 will return a #N/A
Hope this helps,
John
