Need to match values in one column to values in six others and return the value of a cell from corre
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!
|