Hi, Does anyone knows a function that I can lookup datas as below

Return data for look up Frank = MEP2-2, IAEMID-248, GABELLI-250, ML-248,
CSFB-248

Return data for look up Sam = ML-2, UBS-4

Frank MEP2 2
Frank IAEMID 248
Frank GABELLI 248
Frank GABELLI 2
Frank ML 248
Frank CSFB 248
SAM ML 2
SAM UBS 4

Thank You!