| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup Not working as expected
GDay All,
Can anyone tell me why the folling function is not working correctly. =LOOKUP(MIN(R10C4:R63C4),R10C4:R63C4,R10C3:R63C3) The function works only if the lowest value falls within certain cells, but returns #N/A if the lowest value is in another cell. Any help would be appreciated. TIA -- Regards trumpy81 *** Please remove the `_ spam _' trap before replying to this message *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Hyperlink Function not working as expected | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| Application.Volatile not working as expected | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
