| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup value between cells
I have a rather large spreadsheet (7500 rows) and need to be able to find the
value of one cell based on if another value is between the values in columns B and C. For example, if the value I need to reference is 59216, I want to have the formula return the value in column E when column B is 59200 and column C is 59300. Is there a way to do this with LOOKUP or some function? As always, thanks to the contirbutors who make my life much simpler with their expertise! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup from multipe cells | Excel Discussion (Misc queries) | |||
| lookup returning several cells | Excel Discussion (Misc queries) | |||
| lookup a value and return cells | Excel Worksheet Functions | |||
| Lookup without empty cells. | Excel Discussion (Misc queries) | |||
| lookup tables in cells | Excel Worksheet Functions | |||
Threaded Mode
