I need to create a function that will look at a cell two columns to left
and determine if the cell is blank. If the cell is blank, I need to
search vertically for the next cell containing a value above this cell.
The distance to the next cell containing a value will vary. If the
distance did not vary, I could do this with an ISBLANK function
embedded within an IF statement, but the variability has me a little
confused. Any suggestions would be welcomed?
Thanks!
--
tobriant
------------------------------------------------------------------------
tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
View this thread:
http://www.excelforum.com/showthread...hreadid=386539