Vlookup Odd Behavior

[Guest]

New worksheet, in 2k. When a customer creates a vlookup formula in a blank
cell, let's say f2, he expects to get the result in that cell, however, Excel
decides to put it where ever it feels like it and no two places are the same.
Can you think of anything that might be wrong? This particular guy works in
Excel all the time and is quite saavy.

Any help woudl be greatly appreciated.

 

[Gord Dibben]

Lisa

This happens in one particular workbook or worksheet only?

I would look for some event code that randomly moves the displayed value around.

Or all workbooks/sheets including new ones?


Gord Dibben MS Excel MVP

 

[Guest]

New and exisiting workbooks. I will look intothe event code if I can figure
out what that is. Thanks Gord!

 

[Gord Dibben]

If happens in new workbooks then you best look to see if any add-in is doing the
deed.

There would be no code in new workbooks.

Go to Tools>Add-ins and uncheck all and see what happens with your VLOOKUP
formula entry.

If behaviour stops then re-check one at a time until you find a culprit.


Gord