LOOKUP not working, how bizarre

[CatSqueezer]

I have already gotten good help with this spreadsheet l'm working on. It's for keeping scores on a quiz.

However, for the final statement of the scores (ROW 17), LOOKUP only works for the first result in D17. So, l can match the highest score, which goes in D17, with the name of the contestant (in the range i2:i11) who got that score.

For the next highest score, in F17, and the next in H17, then J17 etc. LOOKUP fails to match the scores placed in those cells, with the names in the range i2:i11.

Please can somebody help me fill in the boxes that state "WHAT FORMULA GOES HERE?" in block capitals, all on ROW 17?


Please see attached spreadsheet.

[Richard Buttrey]

You will of course need to upload the workbook

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...w-bizarre.html