Large data base with two sets incident numbers need to be joined to form one file

[pick44]

I am using excel 2016.

I have two large database files with data. The files have "unique" Incident Numbers associated with row data.
I have attached a sample file with a small amount of data which represents my files and the results I need.
The unique number column is highlighted in red in column A and F.
Column A has duplicate numbers and column F does not. But I need to have one file which combines all incident numbers found in Column A. No matter if they are duplicates are non duplicates. If Column A and F match, then data in columns J:S to be added to all Rows found in Columns A:D.

The number of rows of data in Columns A:D are 120,347 whereas the number of Rows in Columns F:S are 99,830.


Because Columns A:D have duplicates, there are 20,517 more rows of data then what is found in Columns F:S.

[Stormin']

Ok, so your "Status" database on the right has the incident number as a primary key (there can only be one status per incident number) and your "NIB" database on the left has the incident number as a foreign key (there can be multiple NIBs per incident number).

This would be much better with a proper database but you can match the data using VLOOKUP or INDEX/MATCH. Take your NIB data and add some columns on the end which look up the NIB data's foreign key against the Status data's primary key and return all the columns you wish.

More info on VLOOKUP and INDEX/MATCH:
https://spreadsheeto.com/vlookup/
https://www.deskbright.com/excel/using-index-match/

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[pick44]

Thank you for your help. Blessings,