ExcelBanter - How can I find value from another workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I find value from another workbook (https://www.excelbanter.com/excel-worksheet-functions/120995-how-can-i-find-value-another-workbook.html)

Jaan

How can I find value from another workbook

Hi All

In column A I have workbook names
A1=0001
A2=0002
....
In column B I trying find formula to find value from workbook columnA
Example:
B1=C1 from workbook (filename fromA1)
All these workbook in C:\My Documents

I hope you understand what I mine

All times are GMT +1. The time now is 06:07 AM.