Find value between range & return text

R

RangeFinder

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Ranges of Cells, Return Separate Value for Each Range 5
Return the value from one range that does not exist in another 0
With F1 value, look at A, if match or partial match return B 5
if value is between two numbers 6
Finding a number within a range of numbers 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
I need Time Range to return Value 4
Lookup value that falls between two values in a range and then som 2

Top