How to find a value in a worksheet which matches an array value?

Hi,

I dumped the entire worksheet(Plan_Mapping) into an array - aPlan. Array is multidimentsional. First column of the array has Plan which I refer to through a constant C_Plan.

I have another worksheet(PlanUIs) (same Excel file)- has only 2 columns - UniqueIdentifier and Plan.

Now while looping through the array, how can I find the value of the array aPlan(C_Plan,i) in the worksheet - PlanUIs and then take the associated UniqueIdentifier and insert this value into a 3rd worksheet - Plan_Link

My code till now is:

Please Login or Register  to view this content.

Any suggestions would help.

Thanks.