I am hoping for some help. I am using a vlookup that the table array is referencing another workbook that will be constantly updated through edit links. I would like to see which file the table is pulling from in another cell so when the file is saved with pasted values, I know which file version was used for the data. Is there a way to do this through a formula? If not, is there a way to do this through a simple VBA?

The vlookup looks like this:

=vlookup(b1,THISDATA,5,false)

And I am hoping to return in A1:

A1 = THISDATA

Any help would be great!