vlookup returns N/A when match exists ('=A1=B1' results in 'TRUE')

[adllewis42]

I would like to think that I am rather proficient with Excel but this has me stumped. Im performing a basic vlookup to match account balances with their account names. In one table I have a list of account numbers and their balances. In another table, I have a list of account numbers and their names. When I perform a vlookup though, I get an N/A for every single cell.

Ive special pasted all the values into new workbooks, Ive double checked to make sure all excessive spaces are gone, and I even found the cells that SHOULD match and when I type the formula of "=cell1=cell2", Excel returns a 'TRUE' so I know they match!

This is so frustrating! Does anyone have any ideas?

 

[Jonmo1]

Can you post the formula, and a sample set of data?
And the exact "=cell1=cell2" formula you used that returns TRUE ?


Another thing to consider is that if the resulting cell from the vlookup contains another formula with #N/A..

 

[Matty]

Are the account numbers text or real numbers? They would both need to be the same for your lookup to work.

You can test them both using:

=ISNUMBER()

Let us know how you get on.

Matty