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