ayrus
09-24-2018, 10:42 PM
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
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