Forum Discussion
How to Index Match from multiple closed workbooks in excel.
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.
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.
- 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".
- 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?
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.