| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look up range and return value
What I need to do:
Using Value "A" (let's say 20), lookup on on a table and find the row that 20 falls in the range of column A and column B (let's say column A is 15 and column B is 25) i want to return the value of column C in the same row. There is a possibility of 150 different rows. Also, value A is in workbook Jobs, and the table is in workbork Tables. Any expertise would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to return a range | Excel Programming | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| drop first row in range and return a new range object | Excel Programming | |||
| Return Range Address from Active Range | Excel Programming | |||
| Return Range in VB | Excel Programming | |||
Threaded Mode
