I currently have about 6 VLOOKUP's which after they run, seem to change themselves and give me #REF errors. So i have to change them all back to their original values.
Does anyone know why this happens....
In the above example, the A:AE will change to A:AB for example....![]()
=VLOOKUP(A:A,'Infill Report'!A:AE,30,FALSE)
It's driving me nuts..
JonesZoid
Bookmarks