gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- 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