L
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
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