Hlookup I think

[Jerk24]

I am looking for help with a simmingly simple formula. I have a sheet the once a week i will add a number to the cell, then i reference that number to a difference cell. i just need to formula to read the cell furthest right, that is non blank.

my data starts in row C3 to K3

thanks in advance, i know someone can do this in their head.

 

[VoG]

Maybe

=LOOKUP(9.9E+307,C3:K3)

 

[Jerk24]

perfect, that is just what i was looking for. Thank you.

 

[Jerk24]

I jumped the gun a bit, I need it to pick up cells with letters too.

 

[VoG]

Try

=LOOKUP(2,1/(1-ISBLANK(3:3)),3:3)

 

[Jerk24]

thank you. that works