For last value in a range:

=LOOKUP(9.99999999999999E+307,B1:B100) adjust range to suit


For returning a blank:

e.g.

=If(Isna(Vlookup.....),"",Vlookup(.....)) or

=If(Vlookup(....)=0,"",Vlookup(....))

Where Vlookup(....) could be any condition.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558625