Vlookup strange problem- limitation?

[aborg88]

Hey

So i got a wierd problem.

imagine i have a table

Col A

1
2
3
4
5
6

Col B

a
b
c
d
e
f

Col C

1

Col D

=Vlookup(C1,A:B,2)

Will give me A. Works fine right? Thats how Vlookups work.

Now consider this:

column A has over 14,000 rows; each row being unique with customer usernames; e.g. Goprenik, _._mob_._ , _L_A_D_I_ , Ect...

Column B is an integer value (floating point)

....

Everyday I get a list of values (some are in my list of 14,000, some arent)

For the users that are in the list I want the Balance.

....

I tried normal look ups and its not retrieving the right result.

however if i do countif(A:A, **username**) i do get the correct count.


IS THERE SME KIND OF LIMITATION TO VLOOKUP IM NOT AWARE OF?

Pls feel free to ask me to uload my excel file if this doesnt make sense.

[Fotis1991]

Hi

Be sure that best way to describe your problem, is to upload a sample workbook.

[aborg88]

hey;

yep i understand but the workbook i have is very big and has sensitive material on it; and would be a breach of my T&C. so i tried to exlplain myself first.

/A

[bebo021999]

Try to rebuild you VLOOKUP as:
VLOOKUP(C1,A:B,2,0)
0 for exact matching.
If failure, send the example file.

[aborg88]

thanks man!

[TMS]

For future reference, you only need to upload a example workbook with some typical but desensitized content to demonstrate the structure, content, formulae and problem(s).

In this case, a sample workbook wasn't strictly necessary as it was possible to hazard a guess at the answer from your description.

However, more often than not, providing a sample workbook will result in a quicker and more accurate answer to your question.

Regards, TMS