kdjonesmtb
New Member
- Joined
- Feb 5, 2010
- Messages
- 31
I have a formula that I would like move external references from a shared drive to SharePoint. Can external references located on a SharePoint site be called within an Excel formula?
Example:
=IF(L30="",(0),IF($L30<200,VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention Schedule\2010\[20100105_ERS_Reference_WellTable.xls]Well Reference Table'!$J$1:$P$65536,5,FALSE),IF($L30<400,VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention Schedule\2010\[20100105_ERS_Reference_WellTable.xls]Well Reference Table'!$J$1:$P$65536,6,FALSE),IF($L30>=400, VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention
SharePoint location for reference file 20100105_ERS_Reference_WellTable.xls:
http://liuconnect/global/GlobalIT/U...8&View={ED68E67F-D85F-48A0-8ABA-64E1B13724A7}
Example:
=IF(L30="",(0),IF($L30<200,VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention Schedule\2010\[20100105_ERS_Reference_WellTable.xls]Well Reference Table'!$J$1:$P$65536,5,FALSE),IF($L30<400,VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention Schedule\2010\[20100105_ERS_Reference_WellTable.xls]Well Reference Table'!$J$1:$P$65536,6,FALSE),IF($L30>=400, VLOOKUP($T30,'z:\Keith.Gittens-Jones\E&P\Engineering\Templates\Risk Retention
SharePoint location for reference file 20100105_ERS_Reference_WellTable.xls:
http://liuconnect/global/GlobalIT/U...8&View={ED68E67F-D85F-48A0-8ABA-64E1B13724A7}