Hi i tried everything that Biff said to do, but when i enter the formula


=IF(ISNA(MATCH(D2,A$2:A$11,0)),"",IF(COUNT(E$1:E1) ,"",VLOOKUP(D2,A$2:B$11,2,0)))

the cell comes up blank. no error, or anythimg.

this formula is too advanced for me so i cant figure out where it might
have gone wrong

any ideas??????????????


--
taran
------------------------------------------------------------------------
taran's Profile: http://www.excelforum.com/member.php...o&userid=25724
View this thread: http://www.excelforum.com/showthread...hreadid=391338