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