Hi,

Was trying to achieve the following - which seems easy in concept...

You look up a row entry on another worksheet and return it to the
current worksheet.

however, if the row entry is blank, return the next row entry down
instead, unless this row is blank in which case return the next one and
so on and so on etc.

Any help to do this appreciated

thanks
bob


--
bobpants
------------------------------------------------------------------------
bobpants's Profile: http://www.excelforum.com/member.php...o&userid=24909
View this thread: http://www.excelforum.com/showthread...hreadid=384472