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:

Function getPlan(Name)
    
Count = 1
For i = 0 To UBound(aPlan, 2)
    'MsgBox (Count & "." & aPlan(C_Plan, i))
    'Take UniqueIdentifier of each plan from the 'PlanUIs' sheet
    
    Count = Count + 1
Next
MsgBox ("There are " & Count & " Plans")

End Function

Any suggestions would help.

Thanks.