View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RangeFinder RangeFinder is offline
external usenet poster
 
Posts: 1
Default Find value between range & return text

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