I need to return the value of a cell in a range that is not blank..

A B C D E
1 5 (return 5 in e1)
2 3 (return 3 in e2)
3 4 (return 4 in e3)
4 (return " " in e4)