Hello,
Currently, have a table as below
<tbody>
Symbol
Value
Group
ABCD
95
Apples
CGRD
80
Oranges
</tbody>
Cell B2 has a formula = vlookup(a2,'\\fs\gd\[PVO Q4 2018.xlsx]Main Sheet'!$A:$Z,18,0). The A2 value can be a part of a different file link, dependent on C2. For example...