Hello,
The top table has the date and descriptions for my drawings. The bottom left table has the drawing numbers and names. If there is an X in the bottom left table, I want the bottom right table to pull the date and description from the top table.
No matter which column the first X is, the bottom right table should return the date and description in the #1 columns. What formulas should I use to achieve this?
The top table has the date and descriptions for my drawings. The bottom left table has the drawing numbers and names. If there is an X in the bottom left table, I want the bottom right table to pull the date and description from the top table.
No matter which column the first X is, the bottom right table should return the date and description in the #1 columns. What formulas should I use to achieve this?
Month: | 02 | 04 | 06 | |||||||||||
Day: | 02 | 04 | 06 | |||||||||||
Year: | 2022 | 2022 | 2022 | |||||||||||
Description: | ISSUED FOR REVIEW - 15% | ISSUED FOR REVIEW - 30% | ISSUED FOR REVIEW - 60% | |||||||||||
1 | 1_DATE | 1_DESCRIP | 2 | 2_DATE | 2_DESCRIP | 3 | 3_DATE | 3_DESCRIP | ||||||
DWG NUM | DWG NAME | Column1 | Column5 | Column6 | ||||||||||
000-01 | COVER SHEET | X | X | X | A | 2/2/2022 | ISSUED FOR REVIEW - 15% | B | 4/4/2022 | ISSUED FOR REVIEW - 30% | C | 6/6/2022 | ISSUED FOR REVIEW - 60% | |
000-02 | DRAWING INDEX | X | X | A | 4/4/2022 | ISSUED FOR REVIEW - 30% | B | 6/6/2022 | ISSUED FOR REVIEW - 60% | |||||
001-01 | LEGEND & SYMBOLS | X | A | 6/6/2022 | ISSUED FOR REVIEW - 60% | |||||||||
001-02 | NOTES | X | X | A | 2/2/2022 | ISSUED FOR REVIEW - 15% | B | 6/6/2022 | ISSUED FOR REVIEW - 60% |