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!
Bookmarks