http://i.imgur.com/ut046ml.png What I want to do is to enter a players name in C17 and then get all his stats to appear automatically. I tried it with this function:
=VLOOKUP($C17,$B$2:$J$10,COLUMN(D17)-1,0)
but I get this error message http://i.imgur.com/6Ql4w3d.png.
What am I doing wrong?
=VLOOKUP($C17,$B$2:$J$10,COLUMN(D17)-1,0)
but I get this error message http://i.imgur.com/6Ql4w3d.png.
What am I doing wrong?