Vloopup to an excel worksheet that has been exported from SharePoint

Hi

I have exported lists from SharePoint and added then as New Worksheets in to an existing Excel Sheet - I can't Vlookup to the Query files from SharePoint in excel.

In short I want to look at the data from one excel worksheet to another, one excel worksheet contains a query table exported from SharePoint.