title: Looking up value of a specific cell subject to values in other cells
body: <p>I have a spreadsheet I use for a game I run which involves a sheet (sheet1) which shows the players their weekly score. This is set up with their name encompassing 4 cells in the 1st row eg columns A-D and then their tally for week is calculated and shown in the 18th row cell of the 4th column encompassing their name eg column D.</p>
  <p>I then have a separate sheet (sheet2) where all of the players weekly scores are added together which is designed with their names listed in column A and their total score in column B. I would like to have some sort of lookup in column B of sheet2 which plucks the players score from the cell of sheet1 (eg D18) based on a match between their name in column A of sheet2 and the 4 cells the name encompasses in sheet1.</p>
  <p>I've tried using Vlookup+Match and Index+Match but not had any joy.
  Is it possible to lookup a specific cell in this way?</p>