Hi All

i have a list of values(column a) i want to lookup from column(b) an
print out store the value in column c into an array.

EG

nme nam %
aaa aaa 1
bbb aaa 2
CCc aaa 3
ddd bbb 2

so if i lookup in name aaa, i want the aaa and 1 to be stored into a
array. Also say i had anouther column would like it to store tha
value as well.

Any help would be appreciated

--
kanuva
-----------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...fo&userid=2791
View this thread: http://www.excelforum.com/showthread.php?threadid=48342