How do i reference another tab in my spreadsheet

[lumpar]

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

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

 

[lumpar]

hello Jim just wanted to just to check

i have the following in my teams tab
b1 c1 d1 e1 f1
code player team value points

i want to be able to type the code in b1 and it references the players tab

example

101 smith chelsea 1.0 12

so will this code do this job, and do i apply to c1,d1,e1,f1?

 

[lumpar]

hello i have got it to reference the first player in the list but i need it to check up to four hundred players how do i manipulate the code to do this please

much appreciated

 

[lumpar]

=VLOOKUP($A5,Players!$B$2:$F$2,2,0) i have this code working, but i need it to reference 400 lines for the correct information, can someone advise what change i would need to apply to the lookup so it would reference other lines

I was thinking $B$2:$B$400 but it doesnt work