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.