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.

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.

Yes. Calculation was set to automatic. I had also tried
using F9 just in case and I have run the formula in the
edit box using specific ranges or range names. Both ways
work correctly in that mode. I also checked that the
range name and spelling was correct
using /insert/name/define. So far still stumped.