So I found the solution to this, but it's fairly dumb and takes a lot of computing time.
Column C: Use concatenate and vlookup to get it a formula that looks like ='C:\data\files\[Master samples.xlsx]Sheet1'!$C$14
Column D: Copy and paste the values so it shows up as text
Use Replace, replace = with = and it'll evaluate as each cell formula is replaced
|