"=VLOOKUP(B1,Indirect(A5)2,FALSE)"

Note that Indirect will not work if the workbook reference in cell A5 is to
a closed workbook.

--
Regards,
Tom Ogilvy


"Superfly" wrote in message
...
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