Hello
I am trying to create a lookup or if statement, i am a bit clueless when it comes to this so apologies.
I have tab 1 of my spreadsheet and in a1 i would like to reference some data on another page my other page would be players, and in the players i would have 4 sections, for example goalkeepers, defenders etc
example is trevor
<tbody>
</tbody>
I would type in trevor in a1 in my first tab and it would then reference the players list and fill in club, value, points, the reference would need to look at goalkeepers, defenders etc.
Can anyone help with this please?
Thanks
Matt
I am trying to create a lookup or if statement, i am a bit clueless when it comes to this so apologies.
I have tab 1 of my spreadsheet and in a1 i would like to reference some data on another page my other page would be players, and in the players i would have 4 sections, for example goalkeepers, defenders etc
example is trevor
Player | Club | Value | Points |
Trevor | Badajoz | 1.0 | 52 |
<tbody>
</tbody>
I would type in trevor in a1 in my first tab and it would then reference the players list and fill in club, value, points, the reference would need to look at goalkeepers, defenders etc.
Can anyone help with this please?
Thanks
Matt