Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link drop-down list of a workbook in to another workbook? | Excel Discussion (Misc queries) | |||
Find cell in Excel2000 workbook with link from another workbook? | Excel Discussion (Misc queries) | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
How to link a NEW workbook back to a summary workbook? | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) |