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

I need Time Range to return Value 4
Compare 2 lists and return value 1
Event recognition. 11
Finding a number within a range of numbers 2
Return a Header Value with 2 vlookup criteria 1
Average Ranges of Cells, Return Separate Value for Each Range 5
Lookup value that falls between two values in a range and then som 2
Sumproduct giving #Value error 5

Top