KL wrote:
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

GDay All,

Once again KL ... THANX!!

That formula did the trick and saved me from a lot of boring/confusing macro
coding!!

It works a treat :)


--
Regards
trumpy81

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