Hi does anyone know how I can break up a formula, so that I can specifiy the
variables by referencing to a cell containing the info that the formula needs

i.e. "=VLOOKUP(B1,[Book5]Sheet1!$A$1:$C$6,2,FALSE)"

How can I break up the above so that instead of specifying the book and
sheet I can just ask it to refer to a particular cell which would contain the
Book and Sheet.

Thanks