Jamesjra wrote:
I now need to be able to display each case respondents data in the
template individually, and basically change the value that is in the
vlookup cell?


I may not have understood you correctly.

Do you currently have formulas like
=VLOOKUP("Fred", Table, 3, False)
and you want to change them so that instead of "Fred" in each formula
you take the respondent's name from a worksheet cell?

If so, simply replace "Fred" by the address of the worksheet cell.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup