How to filter on two different column

[newexcel12]

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.

 

[szakharov7723]

Not very clear.
So you have 3 DBs (are these DBs or datasets ?)
And all of them have same string in file name (which is 000234334 ETC ) ?
Or they have a unique id column for file , that can match through each DB ?