|Try this in Sheet2:|
As per the Excel Help files, the "1" for the range_lookup argument means:
Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
P.S. If you use the pre tags above the comments box you can line up the data in your posts like so:
A B C
1 0 10 Low
2 11 30 Med
3 31 50 High