| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble with lookup in a range of cells.
I am trying to get excel to look up in a range of cells I54:I102 to search
for a specific text "improved" and if true put a numerical value in another cell. I can get it to work if I put it in the first cell but if I put it in any other cell it returns with an error. What is the best formula to use in this instance? Thanks very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup through a Range of Values in different cells | Excel Discussion (Misc queries) | |||
| if function or lookup??? across a range of cells in a row. | Excel Worksheet Functions | |||
| trouble with text lookup ... help please | Excel Discussion (Misc queries) | |||
| return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
Threaded Mode
