Google Spreadsheet Formula to get last value in a row

For me this one works better, mainly because it works with any other formulas in the same row:

=LOOKUP(9999999999; (B2:G2))

I managed to do it :)

Formula

=index(B2:G2;1;counta(B2:G2))

Will update @mik's answer once I have a high enough reputation.

As a more general answer than @mik's, you can have a formula that slides with the placement of the data:

=index(B2:G2, 0, max(ARRAYFORMULA(column(B2:G2)*(B2:G2<>""))) - column(B2) + 1)