I have a random problem with vlookup that I've not been able to figure out.
Sometimes when I try to lookup a value on a different workbook using vlookup,
the formula disappears when I swich to the other workbook. I'm wondering if
this has something to do with the format that the workbooks are save in. To
work around this problem I end up having to copy the worksheet from the other
workbook and paste it into the workbook I'm doing the vlookup in. This
works, but is rather annoying. What causes this problem, and what's the
solution?

If the =vlookup() formula disappears after you save it, close it, and reopen it,
it could be the format of the file (.csv, .prn for example won't save formulas
for you).

But if you're not closing the workbooks--just swapping between them, then I
don't have a guess--I've never seen excel behave this way.

Actually, I have one wild guess. You have a misbehaving macro (pretty
unlikely).

And one other guess (in a whisper). Are you sure it's not something you
do--maybe going back to the wrong workbook? (No offense intended <g.)

goofy11 wrote:

I have a random problem with vlookup that I've not been able to figure out.
Sometimes when I try to lookup a value on a different workbook using vlookup,
the formula disappears when I swich to the other workbook. I'm wondering if
this has something to do with the format that the workbooks are save in. To
work around this problem I end up having to copy the worksheet from the other
workbook and paste it into the workbook I'm doing the vlookup in. This
works, but is rather annoying. What causes this problem, and what's the
solution?

--

Dave Peterson

I am facing the same problem and have been unable to find a solution to it... can anyone help...