VLookup on Text "4-9910"

  • Thread starter Thread starter LinLin
  • Start date Start date
L

LinLin

Hi Everyone

I have a chart of accounts with account number 4-9910
It is text.
I have similar account nos such as 5-9910, 4-1210 etc

When I do a v-lookup from one list of values to another, I get this error:

List A: 4-9910 Value is 5000
List B: VLookup for 4-9910 from List A - Value is Zero

- I have cleared all formats from both cells in List A and List B
- I have inserted the account number again
- I have inserted the account number with apostrophe before it

The V-Lookup works fine for 5-9910 for example.

Any ideas?
It looks to me like it's a bug, I have a list of about 300 account numbers
and this is the only one which the Vlookup doesn't work for.
(I say bug, because it doesn't say, #N/A for example)

Thanks everyone
 
Sorry to waste everyone's time - the number was in list A twice, and first
time it was zero!

So no solution required!

Elementary really!
 
Back
Top