Forum Discussion
Vlookup multiple file help
I need help extracting a number from multiple excel files. This number is not on the same cell in each file however always the cell next to it is the same name i.e "subtotal". It is always on the sam...
Hello, Celia_Alves
Yes, I placed it in the same folder.
Yes the files have more than one sheet, but in all files, the sheet has the same name "Invoice"
The cell differs from one file to another, but in all files, the number I want to extract has a cell next to it with a name "Ins-Takaful".
I need to collect this number and place it in a separate sheet showing "
Invoice number and this number"
I'll attach two files for you to check.
Thanks in advance
Sherouk Saleh, please see file attached and follow instructions on sheet "Instructions."
I hope this helps.