gnaga
Wellknown Member
 Joined
 Jul 9, 2002
 Messages
 700
 Office Version

 365
 2016
 2013
 Platform

 Windows
Hi,
I would like to write the following formula in cell B1 of this workbook
=LOOKUP(MATCH(9.999999999999E+307,C:C))
But the data I am looking up is from the other workbook stored in the directory "C:GNaga" and the workbook name is "Stock.xls"
I want to supply the workbook name to the formula from column A of this workbook.
i.e A1 of this workbook is housing "Stock"
In both the workbook my data is is in Sheet1.
Can anyone help for me? No VBA please.
Thanks
GNaga
I would like to write the following formula in cell B1 of this workbook
=LOOKUP(MATCH(9.999999999999E+307,C:C))
But the data I am looking up is from the other workbook stored in the directory "C:GNaga" and the workbook name is "Stock.xls"
I want to supply the workbook name to the formula from column A of this workbook.
i.e A1 of this workbook is housing "Stock"
In both the workbook my data is is in Sheet1.
Can anyone help for me? No VBA please.
Thanks
GNaga