Vlookup - cannot link to table array

[Dee]

Excel seems unable to complete the Vlookup...when i try to link to th
table array it drops the formula and i cannot link.
Any ideas on why this is happening

 

[Harlan Grove]

Excel seems unable to complete the Vlookup...when i try to link to the
table array it drops the formula and i cannot link.
Any ideas on why this is happening?

What does the formula look like? What do you mean by 'drops the formula'?