Answer: Formula to calculate percentage are= Winning match/total match *100 And copy paste formula of VLOOKUP in to desire cell formula bar. Example in spreadsheet : Winning match=A5 Total match=A6 Write formula in cell D3: =(A5/A6)*100 And write formula of VLOOKUP into cell D4-D6 to retrieve data from desire cell.