I misunderstood your query as 1st column instead of 1st Row. The below will
return the first non-blank entry in row1

=INDEX(1:1,0,MATCH("*",1:1,0))


If this post helps click Yes
---------------
Jacob Skaria


"Spag" wrote:

Thank you for that however this returns the cell A1 entry even if the cell is
blank. I need it to check which cell in the row is not empty and return the
relevant column entry in row 1

"Jacob Skaria" wrote:

The below formula returns the first value in Col A

=INDEX(A:A,MATCH("*",A:A,0))

If this post helps click Yes
---------------
Jacob Skaria


"Spag" wrote:

Hello

I'm trying to look across a row for a non blank cell and return what is in
the first cell of the column in which the non blank cell is found. Does
anybody have any ideas how that could be done?

Thanks