Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance

Is there only one cell in Sheet1 row 1which is not empty?
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

"Steved" wrote:


Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance

Thankyou bj

Is it possible with your formula to ignore Column A, then find data in a Row.

Thankyou.

"bj" wrote:

Is there only one cell in Sheet1 row 1which is not empty?
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

"Steved" wrote:


Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance

Is it possible with your formula to ignore Column A, then find data in a
Row.
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

=INDEX(Sheet1!B1:IV1,MATCH(TRUE,Sheet1!B1:IV1<"", 0))

Array entered.

Biff

"Steved" wrote in message
...
Thankyou bj

Is it possible with your formula to ignore Column A, then find data in a
Row.

Thankyou.

"bj" wrote:

Is there only one cell in Sheet1 row 1which is not empty?
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

"Steved" wrote:


Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish
this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance

Thankyou Biff

"Biff" wrote:

Is it possible with your formula to ignore Column A, then find data in a
Row.
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

=INDEX(Sheet1!B1:IV1,MATCH(TRUE,Sheet1!B1:IV1<"", 0))

Array entered.

Biff

"Steved" wrote in message
...
Thankyou bj

Is it possible with your formula to ignore Column A, then find data in a
Row.

Thankyou.

"bj" wrote:

Is there only one cell in Sheet1 row 1which is not empty?
=index(Sheet1!1:1,match(criteria,sheet1!,1:1,0)

"Steved" wrote:


Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish
this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance