Link to another workbook

  • Thread starter Thread starter John
  • Start date Start date
J

John

Should be simple... but how to I enter a formula that references another
workbook?

IE - =index("DIFFERENT WORKBOOK" $A$3:$C$250,match("THIS
WORKBOOK",$A$3:$A$250,false),match("THISWORKBOOK",$A$3:$C$3,false))

Thanks!
 
in the formula bar enter =
open the other workbook>navigate to your range>touch enter
in the original you will see that part of the formula for you to finish
 
John said:
Should be simple... but how to I enter a formula that references another
workbook?

IE - =index("DIFFERENT WORKBOOK" $A$3:$C$250,match("THIS
WORKBOOK",$A$3:$A$250,false),match("THISWORKBOOK",$A$3:$C$3,false))

Thanks!
Click to expand...


In Excel, hit F1 and then type "Link to another workbook" into Excel Help.
 
Back
Top