newexcel12
New Member
- Joined
- Dec 15, 2019
- Messages
- 1
- Office Version
- 2016
- Platform
- MacOS
Hello everyone,
I have a big problem with a 3 database which have in common a reference number: 000234334 ETC
each database has a reference number which is the same between the three databases.m y problem is that i don't want to do vlookup or use any forumula at all costs and i would have liked the information to be sorted line by line with retrieve the right information from the three databases: x
I can copy and paste the three databases on the same sheet and then filter with the 3 reference columns that the databases have in common, I never manage to filter correctly and I only collect incorrect information.
I have a big problem with a 3 database which have in common a reference number: 000234334 ETC
each database has a reference number which is the same between the three databases.m y problem is that i don't want to do vlookup or use any forumula at all costs and i would have liked the information to be sorted line by line with retrieve the right information from the three databases: x
I can copy and paste the three databases on the same sheet and then filter with the 3 reference columns that the databases have in common, I never manage to filter correctly and I only collect incorrect information.