Finding first instance in row and retrieve data based on position and number in row

[chornyak]

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?

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%

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

22 04 30.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Month:	2	4	6
2		Day:	2	4	6
3		Year:	2022	2022	2022
4		Description:	ISSUED FOR REVIEW - 15%	ISSUED FOR REVIEW - 30%	ISSUED FOR REVIEW - 60%
5							1	1_DATE	1_DESCRIP	2	2_DATE	2_DESCRIP	3	3_DATE	3_DESCRIP
6	DWG NUM	DWG NAME	Column1	Column5	Column6
7	000-01	COVER SHEET	X	X	X		A	2/02/2022	ISSUED FOR REVIEW - 15%	B	4/04/2022	ISSUED FOR REVIEW - 30%	C	6/06/2022	ISSUED FOR REVIEW - 60%
8	000-02	DRAWING INDEX		X	X		A	4/04/2022	ISSUED FOR REVIEW - 30%	B	6/06/2022	ISSUED FOR REVIEW - 60%
9	001-01	LEGEND & SYMBOLS			X		A	6/06/2022	ISSUED FOR REVIEW - 60%
10	001-02	NOTES	X		X		A	2/02/2022	ISSUED FOR REVIEW - 15%	B	6/06/2022	ISSUED FOR REVIEW - 60%
Drawings

Cell Formulas
Range	Formula
G7:G10,J7:J10,M7:M10	G7	=IF(COUNTA($C7:$E7)>=G$5,MID("ABC",G$5,1),"")
H7:H10,K7:K10,N7:N10	H7	=IF(G7="","",DATEVALUE(TEXTJOIN("/",,INDEX(FILTER($C$1:$E$3,$C7:$E7="X"),0,COUNT($G$5:H$5)))))
I7:I10,L7:L10,O7:O10	I7	=IF(G7="","",INDEX(FILTER($C$4:$E$4,$C7:$E7="X"),1,COUNT($G$5:I$5)))