Bloomberg
 

The following request file will return all possible values for
MARKET_SECTOR_DES via ftp.

START-OF-FILE
FIRMNAME=dlsample
REPLYFILENAME=sample.dat
PROGRAMNAME=getdata
PROGRAMFLAG=one-shot

START-OF-FIELDS
LU_MARKET_SECTOR
END-OF-FIELDS

START-OF-DATA
IBM US Equity||
END-OF-DATA
END-OF-FILE

Is it possible to do the same in Excel or via Bloomberg
API?
Thanks,