VLOOKUP forumla for Excel HELP!

[luke.j.dillon]

Hi everyone, I am trying to write a forumula using VLOOKUP and I am gettingan #N/A message.

SCENARIO
Right now I have names of 200 football players in one column and in anothercolumn I have a number list from 1-200. I then have another tab where what I want to do is type in the number in one cell and in another cell the football player's name pops that is associated with that number.

Here is the formula I am using:

=VLOOKUP(B6,ROSTER,3,FALSE)

B6 is where I have the number in the 2nd tab
ROSTER is the name of the tab where I have the 200 list of players
3 is the column that I have the list of football players

PROBLEM:
When I type a number in from 1-99 the player pops in perfectly into the cell. HOWEVER, when I type in a number above 100 (example: 187), I get that #N/A error.

I am trying to figure out what I did wrong with the formula as to why I am getting that #N/A message for only numbers 101-199.

Any help would be GREATLY appreciated.

Thank you.
Luke

 

[Claus Busch]

Hi Luke,

Am Tue, 12 Aug 2014 12:43:21 -0700 (PDT) schrieb
(e-mail address removed):

=VLOOKUP(B6,ROSTER,3,FALSE)

the range on ROSTER is missing.
E.g. try:
=VLOOKUP(B6,ROSTER!$A$1:$C$200,3,FALSE)


Regards
Claus B.