LookUp inquiry

[Exequiel3k]

Hi all,

I'm not very good with lookup but I need it to look at the only ROW-29, COLUMNS A:AF and display the lasy non-empty cell..

I've been playing around with "=LOOKUP(2;1/(NOT(ISBLANK(A29:AF29)));A29:AF29)" but can't get it to work...

Thx for your help!

[CAntosh]

Will there be data after column AG? If not, and you're just looking for the last entry in Row 29, try the following:

=LOOKUP(2,1/(NOT(ISBLANK(29:29))),29:29)

[CAntosh]

If there IS data after AG, then the formula below should work, so long as you're looking for numbers:

=INDEX(A29:AG29,MATCH(9.99999999999999E+307,A29:AG29))

[Exequiel3k]

There's no data after AF29 since AG29 is where I put this formula..
Thanks for the quick reply but it always returns 0 as value :/

[CAntosh]

Ah, thanks for the clarification. I set it to go a column too far. If the value you're expecting is a number, then the formula below should work:

=INDEX(A29:AF29,MATCH(9.99999999999999E+307,A29:AF29))

If it doesn't, could you please post a small sample workbook?

[Exequiel3k]

Works great!

Thanks a lot for your quick help Cantosh

[CAntosh]

My pleasure, good luck!