Lookup and store in array
 

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

Lookup and store in array
 

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)


"kanuvas" wrote in
message ...

Hi All

i have a list of values(column a) i want to lookup from column(b) and
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 an
array. Also say i had anouther column would like it to store that
value as well.

Any help would be appreciated.


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile:
http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=483429