Try changing the formula to this:
=VALUE(INDEX(Lives!B2:B110,MATCH(MAX(Lives!C2:C110),Lives!C2:C110,FALSE),)&"Top live show"&MAX(Lives!C2:C110))
If this doesn't work with your number formatting, then attach a sample workbook - you must be doing something wrong. Instructions at the top of the page.
Bookmarks