lookup value in column

A

Andy

A simple example of what I am looking for:

Sheet 1:

Col A Col B
Jan 125
Feb 100
Mar 95
Apr
.....
Nov
Dec

Sheet 2

Col A Col B
Amount for 95
latest month

Sheet 2 Col B should contain 95. (This being the most recent value from
Sheet 1). If a value was entered next to April on Sheet 1 this would
then appear in Sheet 2 Col B.

I guess I could do an IF Dec <> "", ELSEIF Nov <> "" etc., but I thought
there must be a quicker was of doing this. is there a function that
will do this?

Thanks

Andy
 
Top