Vlookup Problem

[htchandler]

I have a problem with Vlookup when it comes to the vlookup recognizing names, let me explain.

Tab 1 (Master sheet, 1 Column contains the name that I'm having problems with)
Tab 2 (A Cell on this tab is linked to the individuals name on tab 1 and is the tab where I have the vlookup formula)
Tab 3 (Sheet that I keep raw data...Names, SSNs, DOBs, etc, and the information I'm trying to make showup on Tab 2)

When I try to run the vlookup on a certain individual it comes back as indicating that the it's structured "vlookup(name,references cells with data on Tab 3,9,0) The formula works fine for everyone else, except this one guy. If I copy his name off the raw data sheet and paste it into the cell on tab 2, the vlookup works fine. I've tried setting fonts to all the same but have not found a solution. Again, it works fine for everyone except this on guy. Any ideas?

 

[bensonsearch]

Hi,
maybe instead of 0 at end ty putting false

 

[T. Valko]

Hi,
maybe instead of 0 at end ty putting false

0 and FALSE mean the same thing:

=VLOOKUP(A1,C:D,2,0)
=VLOOKUP(A1,C:D,2,FALSE)

Both formulas will work EXACTLY the same. Using 0 instead of FALSE saves a couple of keystrokes!

 

[T. Valko]

I have a problem with Vlookup when it comes to the vlookup recognizing names, let me explain.

Tab 1 (Master sheet, 1 Column contains the name that I'm having problems with)
Tab 2 (A Cell on this tab is linked to the individuals name on tab 1 and is the tab where I have the vlookup formula)
Tab 3 (Sheet that I keep raw data...Names, SSNs, DOBs, etc, and the information I'm trying to make showup on Tab 2)

When I try to run the vlookup on a certain individual it comes back as indicating that the it's structured "vlookup(name,references cells with data on Tab 3,9,0) The formula works fine for everyone else, except this one guy. If I copy his name off the raw data sheet and paste it into the cell on tab 2, the vlookup works fine. I've tried setting fonts to all the same but have not found a solution. Again, it works fine for everyone except this on guy. Any ideas?

See this...

http://contextures.com/xlFunctions02.html#Trouble

 

[bensonsearch]

0 and FALSE mean the same thing:

=VLOOKUP(A1,C:D,2,0)
=VLOOKUP(A1,C:D,2,FALSE)

Both formulas will work EXACTLY the same. Using 0 instead of FALSE saves a couple of keystrokes!

this i didnt know, thanx. learn something new every day

 

[T. Valko]

this i didnt know, thanx. learn something new every day

You're welcome!