I am confused as to why you wish to do this.

If you wish a list of numbers which have entries in column B would you
not sort over column B and block-delete all rows with a blank column B,
then delete column B, and re-sort (if required) over column A.

If, in fact, you wish to use this data as a lookup-range to update data
on a different sheet, then:
assuming you are using the numbers in column A as the lookup value, the
lookup would read something like
=IF(ISNA(VLOOKUP(a1,looktable,1,FALSE)),"Missing
"&a1,IF(VLOOKUP(B5,looktable,2)="","",a1))


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=375853