mlandry62
New Member
- Joined
- Jul 31, 2023
- Messages
- 15
- Office Version
- 2003 or older
- Platform
- Windows
Struggling to get VLOOKUP to work with multiple workbooks.
Second screenshot is the master spreadsheet, which by the way there are 10 of these!
The first sheet looks at the account numbers in Group 4110 to compare against Col B numbers and return the value from Col K to the Visual value.
Hopefully I've explained myself properly.
Issue I have is Multiple Trial Balances (2nd Screenshot) and account numbers in first screenshot have extensions that relate to the multiple trial balances.
Any assistance or advice would be greatly appreciated.
Second screenshot is the master spreadsheet, which by the way there are 10 of these!
The first sheet looks at the account numbers in Group 4110 to compare against Col B numbers and return the value from Col K to the Visual value.
Hopefully I've explained myself properly.
Issue I have is Multiple Trial Balances (2nd Screenshot) and account numbers in first screenshot have extensions that relate to the multiple trial balances.
Any assistance or advice would be greatly appreciated.