Hi
I have attached a broken down example of a sheet I am using, I am not to familiar with vlookup but I managed to get it to work for what I needed.
If you got to cell B9014 you will see the code which has been filled down as you will see.
In cells B9038, B9039, B9040, B9041 it is displaying the wrong data and I cannot work out why. You will see easily what should be there from the data in the range A2:B5000 (actually more like B800).
Any help would be greatly appreciated thanks,
Dan W
Bookmarks