Lookup and store in array

[kanuvas]

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

 

[Bob Phillips]

Look at Find and FindNext in VBA help.

In the array, just use the cell value like

ary(0) = cell.Offset(0,1).Value
ary(1) = cell.Offset(0,2).Value

--

HTH

RP
(remove nothere from the email address if mailing direct)