Hey,
Looked at other threads but can't find a concrete answer.
I need to put the vlookup into a range looking at a closed workbook.
This bit of code will just place this in the range with the variable name inside it instead of what the variable actually holds.
=VLOOKUP(R6C3,INDIRECT("'["& LYS...