| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup last used Row un closed Workbook
I am trying to link to a closed Excel file with this path:
='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7 I want to add this to the end of the previous function: =LOOKUP(10000000000,WeeklyForecastingRM!B:B) Basically, trying to lookup the value in the last used row of a closed Workbook. Can someone help out? Thanks so much! Ryan--- -- RyGuy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup last used Row un closed Workbook
I want to add this to the end of the previous function:
=LOOKUP(10000000000,WeeklyForecastingRM!B:B) Not sure what you mean by that? This should work: =LOOKUP(10000000000,'C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B:B) -- Biff Microsoft Excel MVP "ryguy7272" wrote in message ... I am trying to link to a closed Excel file with this path: ='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7 I want to add this to the end of the previous function: =LOOKUP(10000000000,WeeklyForecastingRM!B:B) Basically, trying to lookup the value in the last used row of a closed Workbook. Can someone help out? Thanks so much! Ryan--- -- RyGuy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup last used Row un closed Workbook
Try this:
=LOOKUP(10E10,'C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B:B) Hope this helps. Pete On Sep 23, 10:54*pm, ryguy7272 wrote: I am trying to link to a closed Excel file with this path: ='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7 I want to add this to the end of the previous function: =LOOKUP(10000000000,WeeklyForecastingRM!B:B) Basically, trying to lookup the value in the last used row of a closed Workbook. *Can someone help out? Thanks so much! Ryan--- -- RyGuy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup last used Row un closed Workbook
=LOOKUP(99^99,'C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!$B:$B) -- Regards, Peo Sjoblom "ryguy7272" wrote in message ... I am trying to link to a closed Excel file with this path: ='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7 I want to add this to the end of the previous function: =LOOKUP(10000000000,WeeklyForecastingRM!B:B) Basically, trying to lookup the value in the last used row of a closed Workbook. Can someone help out? Thanks so much! Ryan--- -- RyGuy |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup last used Row un closed Workbook
Thanks everyone!!!
-- RyGuy "Peo Sjoblom" wrote: =LOOKUP(99^99,'C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!$B:$B) -- Regards, Peo Sjoblom "ryguy7272" wrote in message ... I am trying to link to a closed Excel file with this path: ='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7 I want to add this to the end of the previous function: =LOOKUP(10000000000,WeeklyForecastingRM!B:B) Basically, trying to lookup the value in the last used row of a closed Workbook. Can someone help out? Thanks so much! Ryan--- -- RyGuy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getvalue from closed workbook | Excel Discussion (Misc queries) | |||
| Lookup function Closed files Excel | Excel Worksheet Functions | |||
| Linking to a closed workbook | Excel Worksheet Functions | |||
| Value from a closed workbook | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
