VLOOKUP and #Num Issue

[excel-qs]

I have set up a spreadsheet in the following manner.

NameID Info1.....Info20 VLookupCOl

My hope is to copy/paste data from a text file into the Info1...Info2
columns on a weekly basis. The NameID field is a formula that use
info from the Info1....Info20 fields to generate the id, and th
VLookup uses that information to lookup a value in another sheet of th
excel file to return a simple 1 or 0.

The sheet worked fine until I copied in my first set of text data int
columns Info1....Info20. Now my vlookup does not work. When I loo
at the function in the function builder, I see I have a #Num where th
table array should be. THe data I am referencing still exists an
another non-updated sheet still can reference this data without issue.
On top of that, I can type in a vlookup function in an empty cell o
the worksheet and the function will not resoluve, however, I can type
simple function to say that this cell equals that cell which wil
resolve.

I have had this issue before when copying/pasting data into a workshee
(yes I have Automatic calc on) but now that I want to use this shee
for the next 6 months I find that I am stumped. What is going on?
ti