# Last Cell in Row

• ### Question

• Hello Forum,

I have a Range which the Row is fix (Row 5) and the Col ist variabel and I want to find the last Cell in Row5.

 item status 1 status 2 1 55% 88% 2 20% 30% 3 30% 80% 4 40% 70% 5 50% 60%

Best regards,

Thursday, April 12, 2018 7:35 AM

• 1E+300 is a very large number: a 1 followed by 300 zeros: 1000...0

If you use comma as decimal separator, the formula should be

=LOOKUP(1E+300;5:5)

Regards, Hans Vogelaar (http://www.eileenslounge.com)

• Marked as answer by Wednesday, June 6, 2018 8:08 AM
Thursday, April 19, 2018 7:48 AM

### All replies

• =LOOKUP(1E+300,5:5)

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Thursday, April 12, 2018 8:40 AM
• Hello Hans,

I tried with this Code but I get error!

what mean 1E+300 here ?

Best regards,

Thursday, April 19, 2018 7:36 AM
• 1E+300 is a very large number: a 1 followed by 300 zeros: 1000...0

If you use comma as decimal separator, the formula should be

=LOOKUP(1E+300;5:5)

Regards, Hans Vogelaar (http://www.eileenslounge.com)

• Marked as answer by Wednesday, June 6, 2018 8:08 AM
Thursday, April 19, 2018 7:48 AM