Hi,

As per CLR note (I didn't notice it as I am not used to R1C1 notation) you
can't use VLOOKUP/HLOOKUP, but you may try this formula:

=INDEX(R10C3:R63C3,MATCH(MIN(R10C4:R63C4),R10C4:R6 3C4,0))

Regards,
KL


"trumpy81" wrote in message
...
KL wrote:
Hi trumpy81,

As far as I know, LOOKUP only works correctly if the lookup range is
sorted in ascending order 1,2,3, etc. or a,b,c,etc. If you need to
lookup in an unsorted range then you can use VLOOKUP, HLOOKUP (both
with the fourth argument set to 0 or False) or MATCH.

Regards,
KL

GDay All,

Thanx KL for the help. I tried using VLOOKUP and HLOOKUP but I seem to get
the same results.

Anybody have any other ideas??

I need to first of all find the lowest value in a column, then display the
contents of the cell beside the cell that contains the lowest value, which
actually contains a name.

The cells actually contain times, as in eg: 9:30:00am.

Any help is certainly appreciated.

Thanx again KL


--
Regards
trumpy81

*** Please remove the `_ spam _' trap before replying to this message ***