I have a VLOOKUP function that looks something like this:

=VLOOKUP(A1,[Book3]Sheet1!$A$1:$C$3,3,FALSE)

I want to be able to change the value of the workbook that's used for the
lookup function. Let's say the workbook name is stored in B1.

What do I need to do with the equation to get this to work?

Thanks in advance,
Barb Reinhardt