Hi,
In my active worksheet, I am using the following formula in cell A10
=IF('Adjustments'!A10="","",'Adjustments'!A10)
If there is data in cell A10 of the Adjustments worksheet, then it puts the
data from the Adjustments worksheet into cell A10 of the active
worksheet....if no data is entered in cell A10 of the Adjustments worksheet,
then cell A10 of the active worksheet is blank. ( the data (if any) in cell
A10 of the Adjustments worksheet is a 4 digit code for ex.. 0010)

This is working fine..

However, I'm now trying to use the VLOOKUP fucntion in cell B10 of the
active worksheet..to lookup the description of the code in cell A10 of the
active worksheet. The description is located in another worksheet called
Desc.xls .....I'm using this formula:
=VLOOKUP(A10,Desc.xls!$A$2:$B$1124,2,FALSE)

(The Desc.xls worksheet is opened)

The Formula retruns #NA in cell B10.

If I type over the formula in cell A10 of the active worksheet ...(entering
the code that the formula had there).....then I get the correct description
for the code that is in the Desc.xls file.

It appears the VLOOLUP function doesn't like to lookup data that was
generated by a formula.....
but if I enter the code into the cell....it works perefectly.

Is there a way to make this work with the formula in A10??

Thanks in advance for your help...
Kimberly