Software

Ask something
Question Locked

Excel,=LOOKUP,HELP

0 helpful
1 reply

by drj_the_knife

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need a formula to display the last data in a column if that particular cell is blank, between set ranges of 48 in a column. THEN SEARCH BETWEEN A48 DOWN TO A1 AND DISPLAY THE LAST DATA IF NO DATA THEN DISPLAY NOTHING.

I can't find the answer to this, can someone help?

Just found a solution without the if not data display nothing

=LOOKUP(48,1/(A1:A48<>""),A1:A48)

1 reply

This discussion is closed to new replies.