Look up last cell number containing data

XLOOKUP isn't in your version (2011), so please update your forum profile.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Try:

=LOOKUP(99^99, G3:AC3, COLUMN(G3:AC3))

Maybe some adjusting will be needed as -3 or something...

Maybe one of these:

Formula:

=MATCH(9.9E+307,3:3,1)

Formula:

=MATCH(9.9E+307,G3:XFD3,1)

Originally Posted by tays01s

Now this row's cells, generally contains text, so most of the time it's OK, but there are exceptions.

The suggestions in posts 3 & 4 will tell you what column the last number is in but not the last text or the last of either if the type is unknown.
Your original formulas were sort of on the right track but you don't want the MATCH function but instead introduce the COLUMN function.
So you could try

Formula:

=LOOKUP(2,1/(3:3<>""),COLUMN(3:3))

However, I would generally recommend not to use the whole row reference. I would pick a smaller range but make sure it would be big enough to cover any data that you might have.
For example it might be

Formula:

=LOOKUP(2,1/(A3:AZ3<>""),COLUMN(A:AZ))

Another function option would be

Formula:

=AGGREGATE(14,6,COLUMN(A:AZ)/(A3:AZ3<>""),1)

MATCH with match type 0 will return you first instance.
Some of above solution will return you latest position like for example =LOOKUP(2,1/(F3:AZ3<>""),COLUMN(F:AZ))

Updated sample file with a variety of solutions.