I have a workbook, covering six aircraft, organized by a set list of Task Card numbers.

In this workbook are specific details for each aircraft, entered as six different 'Tables': N705DN, N710DN, N463AC, N701DN, N709DN, and N703DN.

Task Card numbers are in columns: C, M, W, AG, and BA,
Drawing references are in columns: G, Q, AA, AK, AU, and BE
In the range of rows 4 - 1133 respectively.

There is also a seventh table (Top Collector) containing all released reference drawings for all of the aircraft, in columns: BJ, BK, BL, BM, BN, BO, BP, and BQ rows 4 - 724.

Some drawings may be referenced on multiple Task Cards, and some Task Cards may reference multiple drawings.

What I am trying to do is populate the Task Card numbers, for each aircraft, that refer to Top Collector drawings.

I have attached a sample of my workbook for reference.



I think that this could be done with a formula but have no luck with any I have tried to write.

Any help would be appreciated!

Attached Files

TASK CARD VERIFICATION ALL AC 09052024 v2.xlsx (386.4 KB, 8 views)

Can you show in file a sample of results in file.

That would probably help... Here you are, I added columns BR - BW (Rows 4 - 724 and 731 - 748) to be populated with the results...

Attached Files

TASK CARD VERIFICATION ALL AC 09052024.xlsx (396.0 KB, 4 views)

I am continuing to play with finding a solution and came across 'FILTERING' and 'LOOKUP', so I tried both - in the OTHER REFERENCES (BK730).

For LOOKUP I tried:

=LOOKUP(BK731,$G4:$G1133,$C4:$C1133)

This worked, but only returned 1 of the 13 instances where this reference (BK731) appears. I need all 13 to populate.

For FILTER I tried:

=FILTER(G4:G1133,BU731=C4:C1133)

This only returned a zero.

Still trying...

This .jpg may also help understand what they are asking me to do...

Attached Images

2024-09-09_14-17-20.jpg (190.2 KB, 13 views)