Link to another workbook
 

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!

Link to another workbook
 

in the formula bar enter =
open the other workbooknavigate to your rangetouch enter
in the original you will see that part of the formula for you to finish
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Link to another workbook
 

John wrote:
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 Excel, hit F1 and then type "Link to another workbook" into Excel Help.