Yes that true JE McGimpsey what you say but when you have use

=IF(ISNA(MATCH(A1,J:J,FALSE)),"",VLOOKUP(A1,J:K,2, FALSE))


in a couple thousands rows the calculations takes a long time. Oh well
I thought there is a custom format for that.


Thanks guys.


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=562310