Extract last non empty cell of row (ignoring empty cell containing formula) Google Sheets.

[Steinmeyer25]

Hi all,

I am having some problems making up a formula that extracts the last value (text) of a row.
It would be for row 33 in the screenshot. Right now the value in G33 should show, but the cells after G33 all contain formulas resulting in a blank cell.
By filling in the form, H33, I33,... and so on also show a value. The formula should than change to the last real value of the row.
Right know every formula i used counted the "empty" cells too, containing a formula.

Thank you all in avance,

Kind regards

 

[Fluff]

Hi & welcome to MrExcel.
Is this for Excel, or Google Sheets?

 

[Steinmeyer25]

Hi & welcome to MrExcel.
Is this for Excel, or Google Sheets?

Hi,
This is for google sheets

 

[Fluff]

Thanks for that, in future please post such questions to the General Discussion & Other Applications section of the board & make it clear that it's for Sheets.
I have done it for you this time.

 

[Fluff]

Not sure if this works in Sheets, but try

=LOOKUP(2,1/(B33:R33<>""),B33:R33)

 

[Steinmeyer25]

using this formula it says "#N/A, Did not find value '2' in LOOKUP evaluation".

 

[Fluff]

Try wrapping it in arrayformula