Col "A" Col "B"
8/18/06 Vlookup formula (result is $5)
8/21/06 Vlookup formula (cell not updated yet so result shows
#N/A)
Sum() (result shows #N/A)

Col "B" is linked to another worksheet. 8/21/06 row will get the result of
"#N/A" because the vlookup formula won't get updated until 8/21/06. So the
sum total also gives me the result of "#N/A". How can I get the sum total
result of ($5) on Col "B" row 3..

Thanks.

Dinesh