Lookup help needed

[Deb6508]

Hi All,
What I need is help with a LOOKUP.


I have a worksheet that is displaying the following information:

Column A = Team name
Column B = Total count of Reviews
Column C = Number of Correct Reviews
Column D = Number of Incorrect Reviews
Column E = % of Accuracy

Rows 8 - 18 include the following information

Row 8 is Header information
Rows 9-17 = One row of information for each team ie. row 9 = B1001, row 10 = B1002, row 11 = B1003.... row 17 = B1009

Row 18 = the sum of information of rows 9 - 17 with cell A18 = Dept 1 (text)

I have a total of 9 Depts averaging 9 teams per dept. and at the final row for each dept is the same the sum of the teams in that Dept with the last cell in Column A for each team range having the Dept name.

I have a calculation that displays the bottom 3 teams by percentage using this calculation:

=MIN(E$53:E$61,E$42:E$50,E$31:E$39,E$20:E$28,E$9:E$17) This calculation is in cell H58, H59 and H60.

In cells G58, G59 and G60 is where I need to lookup the value in H58. Column E is where the match will be and column A is where the Team Number for cell G58 needs to be. This would be an easy lookup except I have a blank row and a Dept number summry row that keeps column A from being a true sequencial column.

If anyone can help I would really appreciate it!!!!
Thanks in advance!!!!

Deb

 

[GlennUK]

I don't see how your formula can give the 3 bottom teams ... can you explain? And will the bottom scores ever be tied? And if so what if 4 teams get the same bottom score, how would you choose three out of the four?