function tournament(range) {
  // create output array
  var output = [];

  // add header names
  output.push(["Name", "Number"]);

  // create table
  for(var i=2, iLen=range.length; i<iLen; i++) {
    for(var j=0, jLen=range[0].length; j<jLen; j++) {
      // push letter, ring number * 100 + tournament into array
      output.push([range[i][j], (range[0][j] * 100) + (i-1)]);
    }
  }

  // return table
  return output;
}

function calcNum(value) { //Function with the value to search for as parameter
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  var rangeRow = 4;  //First row of range to search in
  var rangeCol = 2;  //First column if range to search in
  var rangeRows = 3; //Number of rows of range to search in
  var rangeCols = 6; //Number of columns of range to search in

  var range = sheet.getRange(rangeRow, rangeCol, rangeRows, rangeCols); //Saves the range to a variable
  var values = range.getValues(); //Saves values in range to an array

  var valRow; //Defines variable for row of value to search for
  var valCol; //Defines variable for column of value to search for

  var ringNum; //Defines variable for ring number
  var tourNum; //Defines variable for tournament number

  for(var i = 0; i < rangeRows;i++){ //Loop to look through all rows in range
    for(var j = 0; j < rangeCols; j++){ //Loop to look through columns in current row
      if(values[i][j] == value){ //If current cell from loops is equal to value (that we're searching for)
        valRow = i + rangeRow; //Row of found value
        valCol = j + rangeCol; //Column of found value
      }
    }
  }
  ringNum = sheet.getRange(2, valCol).getValue(); //Gets ring number (value of cell in row two, column from found value)
  tourNum = sheet.getRange(valRow, 1).getValue(); //Gets tournament number (value of cell in row from found value, column 1)

  return ringNum * 100 + tourNum; //Returns Your value
}