Any ms excel experts on here? I want to create a dynamic vlookup by using a list of filenames from a range of cells i.e Doc1 range A1:A5 contains filenames for docs to be accessed.
So e.g cell value will be =vlookup(B3,[Doc2]Worksheet1!A1:J20),1,false)
I want to replace the [Doc2] value...