| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find value between range & return text
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND function does not return ZERO when text is not found | Excel Worksheet Functions | |||
| Find closest match and return next highest number in range | Excel Discussion (Misc queries) | |||
| Find text and return - NOOB question | Excel Discussion (Misc queries) | |||
| Look for similar text and find the largest value and return value | Excel Discussion (Misc queries) | |||
| find the first blank cell in a range and return me it's position | Links and Linking in Excel | |||
Linear Mode
