Getting all Sedol symbols for BB symbols

[thisisrahul]

Hi,
i have a list of scrips (BB code); i want to have their respective Sedol symbols from Bloomberg.
I have used few of bb functions (e.g =bdh(), bdp() ), can sombody tell me how to get the desired data in excel.


Thanks,
Rahul Mishra

 

[hterrebrood]

If cell A1 contains a bloomberg code such as
12 HK
then in cell A2 enter =BDP(A1&" Equity","ID_SEDOL1")

Best,

Hank