Lookup last used Row un closed Workbook

R

ryguy7272

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---
 
T

T. Valko

I want to add this to the end of the previous function:
=LOOKUP(10000000000,WeeklyForecastingRM!B:B)
Click to expand...

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 said:
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---
Click to expand...
 
P

Pete_UK

Try this:

=LOOKUP(10E10,'C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B:B)

Hope this helps.

Pete
 
P

Peo Sjoblom

=LOOKUP(99^99,'C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!$B:$B)
--


Regards,


Peo Sjoblom
 
R

ryguy7272

Thanks everyone!!!

--
RyGuy


Peo Sjoblom said:
=LOOKUP(99^99,'C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!$B:$B)
--


Regards,


Peo Sjoblom

ryguy7272 said:
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---
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from Closed Workbook 3
Last Row used in calculation 4
Getting data from a closed wbook 45
Finding NEXT to last, non zero numeric value in a row 3
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
Run Excel Macro from Access 2
Worksheet(s) open to last used row 5
Table_array lookup through a define list 10

Top