Return Highest Value by Name

**dodger999** · 03-04-2011, 06:40 AM

Hi,
How do i show the team name from coloumn 1 with the highest value from column 2 so that it reads in E24.I have tried vlookup with max but get #N/A

thanks in advance

**Domski** · 03-04-2011, 06:53 AM

Try this: =INDEX(B3:B23,MATCH(MAX(E3:E23),E3:E23,0))

I'd ditch the merged cells as well. They'll only cause you problems.

Dom

**dodger999** · 03-04-2011, 06:56 AM

I thought the merged cells were part of the problem but im unable to ditch them due to a whole heap of data and boxes above the league table is there a way around it.

**Domski** · 03-04-2011, 07:43 AM

Merged cells can be a problem when selecting cells to include in a formula and are even more of a pain if you get to using VBA.

The way round it would be to lay your workbook out differently. Keep your data on one sheet and your summary tables etc on different ones.

If you want to achieve the same effect as merging cells use center across selection instead.

Dom