when frank is in cell a1, mep2 is in cell b1 and 2 is in cell c1 use the
following function:

=a1&" = "&b1&"-"&c1

there also is a formula named "concatenate" you can use but this does
exactly the same as using "&"

hope this does it.

"Frank" wrote:

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!