Thank you very much max!
I was playing around with the formula and figured out it works if I
removed one of the columns in the VLOOKUP part of the code.

For example, C3 says
=IF(A$3="","",IF(ISNA(MATCH(TRIM(A$3),$A$4:$A$101, 0)),"-",VLOOKUP(TRIM(A$3),$A$4:$J$10,{*-3-,-*-4,5,6,7,8,9,10},0)))

Then D3 says
=IF($A$3="","",IF(ISNA(MATCH(TRIM($A$3),$A$4:$A$10 1,0)),"-",VLOOKUP(TRIM($A$3),$A$4:$J$10,{4,5,6,7,8,9,10},0 )))

And so on all the way to J3

Thanks alot max!


--
fluci
------------------------------------------------------------------------
fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896
View this thread: http://www.excelforum.com/showthread...hreadid=393190