Lookup and store in array

[kanuvas]

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.

[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)


"kanuvas" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>