I have an array with 3 columns; (1) column A is labeled less than or equal to
and contains the lower range of values; (2) column B is labeled greater than
or equal to and contains the upper range of values; (3) column C is a
discrete value. There are over 500 rows in my array in a continuous
sequence. Example, row 1 is 0,10,[value], row 2 is 11,20,[value, row 3 is
21, 30,[value].

I want to do a lookup on the array using a separate file that has 2 columns.
Column A has a value to match with the range in each row of the array and
column B has a value to be returned.

How would I do this in Excel? I am familiar with a 2 column vlookup but
have never tried it with ranges.

Thanks
Bill