Hi Everyone,

I have been struggling to obtain the perfect excel function formula for a large coding excel file which I am currently working on. I have been using vlookup to lookup against two separate spreadsheets using TEXT as a lookup value, if the two TEXT (Sheet 1, Column A verses Sheet 2, Column A) matched then it would return the NUMBER code from Sheet 1, Column B.

Here is the vlookup formula that I am currently using:
=VLOOKUP(A2,'Sheet 1'!A:C,3,FALSE)

Although it appears to work, I have found that because the file is so large, vlookup sometimes returns the wrong NUMBER code and has a conniption and randomises the order.

I hope this makes sense? Any assistance or tips would be greatly appreciated.