Hi ,
Thanks a lot for the prompt response. but this list is a dynamic one where switchcase cannot be used
“currency” and “account” are inputs to this excel datatable
it should perform a match with first 2 characters of currency and last 4 digits of account number in the order as mentioned in the main post.
Regards,
G