I have 2 saved excel documents and want to do a vlookup. I can do vlookups normally when the data is all in 1 saved document. When I try to select in the table array field the second saved document, I am unable to select any data to search. it goes to the second saved sheet, but the vlookup block is not present so that I can choose the relevant columns in the second saved document. I thought originally that it was a compatability issue between 97 and 2007, but it is not the case as I saved both these documents as 2007 doc.

Please I need urgent assistance on how to get past this issue.