=INDIRECT(A1 & "!B7")

Where A1 =[List.xls]n1


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"INDIRECT" wrote in message
...
How to use =INDIRECT(A1 & "!B7") if B7 is in another worksheet on another
workbook? For example:
workbook name=List
worksheet name=n1