|
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 |
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 |
| All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com