Vlookup returning wrong data

[voklarl]

I have several lists of data that resembles like this:

Value No.
1234 1001
-1234 5001
5678 1002
-5678 5002
9012 1003
-9012 5003
etc

And in another sheet Im doing a vlookup function to assign numbers to respect value.
range("D1").formula = "=VLOOKUP(C1,Dummy!B:C,2,FALSE)"
For example, if cell C1 is "-1234", D1 will return "5001".

Problem is, while in some lists the formula works just fine, there are some specific lists that give out totally opposite outcomes.
For example, if cell C1 is "-1234", D1 will return "1001" instead of "5001", while when cell C1 is "5678", D1 will return "5002" in stead of "1002".

The lists give out numbers and values in exactly same formats, while the formulas and the cells are exactly the same. Could someone please help me figure out what is happening here?

[dilipandey]

HI Voklari,

Welcome to the forum.
Vlookup returns data basis on first match and may be it is finding any match before the result your are considering. Suggest you to check this point.


Regards,
DILIPandey
<click on below * if this helps>

[voklarl]

Thx, mate, I'll check all the references again and see if I can be more specific.

Will be good if this eliminates the problem.

[dilipandey]

sure.. I am also curious to know the outcome

Regards,
DILIPandey
<click on below * if this helps>