VLOOKUP - Return the Column with the highest value

[redhots4]

Suppose Column A contains the letters A-Z. The range B2:Z26 contain numbers ranging in value from 1 to 100. I want to perform a lookup against Column A and then return the highest value in the corresponding row. For example, if I do a VLOOKUP for "G" and "G" appears in Row 12, Excel should find the highest value in Row 12 and return that to me.

Can you help me figure this out?

 

[Jonmo1]

Try

=MAX(INDEX(B2:Z26,MATCH("G",A2:A26,0),0))

 

[T. Valko]

Suppose Column A contains the letters A-Z. The range B2:Z26 contain numbers ranging in value from 1 to 100. I want to perform a lookup against Column A and then return the highest value in the corresponding row. For example, if I do a VLOOKUP for "G" and "G" appears in Row 12, Excel should find the highest value in Row 12 and return that to me.

Can you help me figure this out?

Try this...

Book1
	A	B	C	D	E
2	A	67	96	16	37
3	B	34	2	82	34
4	C	49	62	99	7
Sheet1

Find the max value for "B":

=MAX(INDEX(B2:E4,MATCH("B",A2:A4,0),0))