Hi

Try
=INDEX(A1:G1,MATCH(MAX(A2:G2),A2:G2))

--
Regards
Roger Govier



"dim" wrote in message
...
Hi,

I've been trying this with variations of the =MAX function but cant get it
to work... :-(

I have a row of text entries as column titles in every second column, e.g:
A1, C1, E1, G1 etc

Below those text titles, I have numeric values. e.g: A2, C2, E2, G2 etc

I want to get the highest number from row 2, and then display the column
title from that row......

......any ideas?