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 ***