Max and lookups

Hi,

Can anyone help me with this?

2 3 4 5 6 7 8
73 120 98 56 45 89 84
108 110 73 130 98 56 45
89 84 108 93 73 120 98

I have the following table of data and I want to look in each row to find
the highest value (which I would do with Max I guess), then return the number
at the top of the column for that number.

Eg Row 2 highest number 120 value in top row 3
Row 3 Highest number 130 value in top row 5

Have tried Lookups but not having much success. Any ideas would be
gratefully appreciated.

Andy

=INDEX($A$1:$G$1,,MATCH(MAX(A2:G2),A2:G2,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ajayb" <ajayb@discussions.microsoft.com> wrote in message
news:93B2C6E3-34EB-4AAF-997B-F18D5489212D@microsoft.com...
> Hi,
>
> Can anyone help me with this?
>
> 2 3 4 5 6 7 8
> 73 120 98 56 45 89 84
> 108 110 73 130 98 56 45
> 89 84 108 93 73 120 98
>
> I have the following table of data and I want to look in each row to find
> the highest value (which I would do with Max I guess), then return the
number
> at the top of the column for that number.
>
> Eg Row 2 highest number 120 value in top row 3
> Row 3 Highest number 130 value in top row 5
>
> Have tried Lookups but not having much success. Any ideas would be
> gratefully appreciated.
>
> Andy
>

Marvellous Bob, it works a treat.

Thanks

Andy

"Bob Phillips" wrote:

> =INDEX($A$1:$G$1,,MATCH(MAX(A2:G2),A2:G2,0))
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "ajayb" <ajayb@discussions.microsoft.com> wrote in message
> news:93B2C6E3-34EB-4AAF-997B-F18D5489212D@microsoft.com...
> > Hi,
> >
> > Can anyone help me with this?
> >
> > 2 3 4 5 6 7 8
> > 73 120 98 56 45 89 84
> > 108 110 73 130 98 56 45
> > 89 84 108 93 73 120 98
> >
> > I have the following table of data and I want to look in each row to find
> > the highest value (which I would do with Max I guess), then return the
> number
> > at the top of the column for that number.
> >
> > Eg Row 2 highest number 120 value in top row 3
> > Row 3 Highest number 130 value in top row 5
> >
> > Have tried Lookups but not having much success. Any ideas would be
> > gratefully appreciated.
> >
> > Andy
> >
>
>
>