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

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

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

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

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