Hi,

I have following Master data defining Code and its Value (with duplicates) 

 
Sno
Code
Value



1
VB
Find 1



2
VB
Find 2



3
VB
Find 3



4
VB
Find 4



5
VB
Find 5



6
BB
FindX 1



7
BB
FindX 2



8
BB
FindX 3
Wondering if it is possible to iterate and extract data using (Match and Index) for following results

  

Code
Match Value
VBA Result



VB
Find 4
Find 4



BB
FindX 2
FindX 2
As it can be seen in the masterData, "VB" has following values - Find1, Find2, Find3 and Find4.
So is it possible to take Code and MatchValue as Function parameters and return result when it matches with MatchValue

Any suggestions will be of great help.

many thanks
Surya