Hi there,

I'm working in Excel 2002, SP3.

I have the data with the following format -

APC (Name : APC77) (Value : 200)
APC (Name : APC3157) (Value : XXX)
APC (Name : APC1406) (Value : 2000)
APC (Name : APC1426) (Value : 90)
APC (Name : APC74) (Value : 250)
APC (Name : APC3680) (Value : 10)
APC (Name : APC3683) (Value : 100)

BPC (Name : 3318) (Value : A) (Desc : (old))
BPC (Name : 3143) (Value : A) (Desc : (new))
BPC (Name : 3526) (Value : A) (Desc : (new))
BPC (Name : 3678) (Value : A) (Desc : (new))
BPC (Name : 3131) (Value : A) (Desc : (new))
BPC (Name : 3244) (Value : B) (Desc : (old))
BPC (Name : 3334) (Value : A) (Desc : (old))

I wish to use two lists, one called APC_List and the second called
BPC_List. I'd like to use the name as a key to the Value and Desc, if
possible. What datatypes might I use to achieve this? How would you
implement this?

Thanks for your help,

Barry.