Forum Discussion
Solved
How to Index Match from multiple closed workbooks in excel.
Dear Tech Community, I am trying to reference multiple closed Excel workbooks with different file paths and file names. My initial approach was to define the file path and file name in different ...
Here is a new sample workbook.
The current values in G5:UU5 are just dummy values.
First, enter some valid lookup values in G5, H5, etc. You don't have to do all of them, just a few for now.
Next, correct the values in A7, B7 and C7, or if they are already correct, select one of them, press F2, then press Enter.
Then look at G7, H7, etc. Hopefully, they will now contain formulas.
If that works, add data for a different workbook in A8 to C8 and then look at G8, H8 etc.
Assuming that the layout of your worksheet is the same as that of my sample worksheet, yes - copy the code as I described a few replies ago.
Ok so I referred to my sheet and the values you put in columns A, B, C is actually in C, D and E. Do I just change the code and put C in place of A , D in place of B and E in place of C?
- Hi Hans....It has finally worked really appreciate all your help and guidance. Thank you so much.
- Sorry i meant to say D, E and F (i.e replace A with D, B with E, and C with F.
Yes: for example, "A7:C500" becomes "C7:E500".