=IF(A1="","",VLOOKUP(A1,C1:E3,3))


"RangeFinder" wrote:

I need help searching ranges and returning text when the value is in the range.

Column A has many rows with values. Columns C & D has many ranges. Column
E has the value that I want to return for each cell in column A if it is
between one of the ranges in Column C & D. The ranges do not have consistent
spacing.

For example,
Column C (range minimum) Column D (range maximum) Column E
1 100
UPS
101 150
FEDEX
151 240
Local Co.

If the cell in column A was 125, I would want the formula to return FEDEX