Is Calculation set to Automatic in Tools/Options/Calculation?

Also, when you copy, are you ensuring that your lookup table is
remaining costant - I'd suggest you use Sheet2!$A$2:$B$8350 or
else name the range and use the name.

In article ,
"Dave K." wrote:

I am using the following formula, =VLOOKUP(A2,Sheet2!
A2:B8350,2,FALSE).

When I execute the formula with edit formula, it returns
the expected value. But when I have the formula just in a
cell, it returns nothing. It also seems to do nothing
when I copy it to another cell. Is there a trick to
getting this sort of formula to work when it is in a
cell? The data it is looking up is in another worksheet
within the same workbook, thus the Sheet2! reference.
Thanks for any info on this.