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
Last edited by VBA Noob; 11-14-2008 at 09:19 AM.
It appears you're trying to search a column one sheet against data on another sheet? Is that so? VLOOKUP only works on a contiguous table. The range you're looking in needs to have the same column range as the lookup value range....and on the same page.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It looks at another sheet which is populated from a web report and updates my sheet accordingly with any new data etc...
The data is formatted pretty much the same on both sheets.
JonesZoid
Try using absolute values, if the formula gets moved it won't change then
=VLOOKUP($A:$A,'Infill Report'!$A:$AE,30,FALSE)
Not tested though....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks