Find Left and Top

[Pestomania]

Good Day,

I am trying to write a formula that will find the first "not null" cell to the right and then return data in Row 1 of that column. I would prefer this not be a macro just for simplicity. Any thoughts?

Example table:

8/1/2022​

8/8/2022​

8/15/2022​

8/22/2022​

8/29/2022​

9/5/2022​

9/12/2022​

9/19/2022​

9/26/2022​

10/3/2022​

10/10/2022​

10/17/2022​

10/24/2022​

10/31/2022​

11/7/2022​

11/14/2022​

11/21/2022​

11/28/2022​

12/5/2022​

12/12/2022​

12/19/2022​

12/26/2022​

Number

Start

815

8/22/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

XR

T

816

9/5/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

XR

T

817

9/19/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

XR

T

818

10/3/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

XR

819

10/10/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

820

10/17/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

T

821

10/24/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

822

10/31/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

X/Y

823

11/7/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

X/Y

824

11/14/2022​

Start

Start

CB

X/Y

X/Y

X/Y

X/Y

825

11/21/2022​

Start

Start

CB

X/Y

X/Y

X/Y

826

11/28/2022​

Start

Start

CB

X/Y

X/Y

827

12/5/2022​

Start

Start

CB

X/Y

828

12/12/2022​

Start

Start

CB

829

12/19/2022​

Start

Start

830

12/26/2022​

Start

 

[Fluff]

Will the cell always have "Start" in it?
Also where do you want the result?

 

[Pestomania]

Will the cell always have "Start" in it?
Also where do you want the result?

It should state "Start" but if not, I will modify that statement.

The date in the second column is where it should be returning the result.

 

[Fluff]

Ok how about

++Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1			01/08/2022	08/08/2022	15/08/2022	22/08/2022	29/08/2022	05/09/2022	12/09/2022	19/09/2022	26/09/2022	03/10/2022	10/10/2022	17/10/2022	24/10/2022	31/10/2022	07/11/2022	14/11/2022	21/11/2022	28/11/2022	05/12/2022	12/12/2022	19/12/2022	26/12/2022
2	Number	Start
3	815	22/08/2022				Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T		XR		T
4	816	05/09/2022						Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T		XR		T
5	817	19/09/2022								Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T		XR		T
6	818	03/10/2022										Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T		XR
7	819	10/10/2022											Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T
8	820	17/10/2022												Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y		T
9	821	24/10/2022													Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y
10	822	31/10/2022														Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y	X/Y
11	823	07/11/2022															Start	Start	CB	X/Y	X/Y	X/Y	X/Y	X/Y
12	824	14/11/2022																Start	Start	CB	X/Y	X/Y	X/Y	X/Y
13	825	21/11/2022																	Start	Start	CB	X/Y	X/Y	X/Y
14	826	28/11/2022																		Start	Start	CB	X/Y	X/Y
15	827	05/12/2022																			Start	Start	CB	X/Y
16	828	12/12/2022																				Start	Start	CB
17	829	19/12/2022																					Start	Start
18	830	26/12/2022																						Start
19
Sheet3

Cell Formulas
Range	Formula
B3:B18	B3	=INDEX($C$1:$X$1,MATCH("start",C3:X3,0))

 

[Pestomania]

This solution was perfect! Now the next question is, I want to do the same thing but I want to find the first "number value" starting from the left and then returning the top row value for that column.

 

[Fluff]

As that is a different question, it needs a new thread. Especially as there are no numbers in your data.