Vlookup pointing to a cell to get a tab name

[SandsB]

Here's my simple VLOOKUP:
=IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"")

I want to use the same file for multiple people by using a drop down in A1 to get the name of the person, which is the name of a tab in another file, to do the lookup. There's a tab in that other file for every person on the team.

So what I'd like to end up with is a VLOOKUP the works like this would if it were legal code:
=IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]$A$1'!$E$2:$F$569,2),"")

Changing a specific name, Bob, to a cell reference, A1. That would let me replace the name in A1 with any one of a couple dozen other names and get the results I need.

 

[t0azt]

[COLOR=#333333]=IFERROR(VLOOKUP(C3,INDIRECT("'R:\Patient Results\[050119.xlsx]"&$A$1"'!$E$2:$F$569",2),"")[/COLOR]

 

[SandsB]

This gives me an error. "we found a problem with this formula. Try clicking insert formula...."

 

[t0azt]

Missed an &

[COLOR=#333333]=IFERROR(VLOOKUP(C3,INDIRECT("'R:\Patient Results\[050119.xlsx]"&$A$1&"'!$E$2:$F$569",2),"")[/COLOR]

 

[SandsB]

Maybe but the parentheses don't match.