Vlookup problems

[katiapro93]

Hello everyone, it seems lately I am getting stuck alot. I am hoping that someone can give me a fix to this problem. First, I am working on Excel 2007. I have a spreadsheet that had alot of columns which are doing various things including vlookups and mathamatical equations. What I need now is for 1 column say "B" to look at "A" (which has its information by a vlookup and inputted into the cell as a number) and bring back what it finds, but I keep getting #N/A or #REF. Can someone help? Here is an example below.

A B
610200 billbacks

Key is as follows: (the key is on the same workbook just a different worksheet)

A B
610200 billbacks
610300 shows
610400 rebates

 

[barry houdini]

Can you post the formula that gave you an error?

 

[katiapro93]

in the value cell "A" I have:

=VLOOKUP($G767,'C:\DOCUME~1\afraga\LOCALS~1\Temp\[SPR Form Version 14.1 ATLANTA.xls]SPRRECAP'!$B$2:$Y$2000,11,FALSE)

in the cell where I want my answer "B" I have this formula:

=vlookup(A4,key!$G$397:$H$428,2,false)

 

[barry houdini]

and the second one doesn't work?

It's probably a "data type mismatch", your lookup values are numbers and the lookup array is text...or vice versa? Does either of these work?

=vlookup(A4+0,key!$G$397:$H$428,2,false)

=vlookup(A4&"",key!$G$397:$H$428,2,false)

 

[katiapro93]

AWESOME!!!! the +0 worked. What does +0 do? You are just unbelievable. I wish I can know half of what you guys know.