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)