I end up writing this formula:
=if(bdp(A2&" Equity","GICS_SECTOR_NAME")="#N/A N/A",bdp(A2&" Equity","FUND_INDUSTRY_FOCUS"),bdp(A2&" Equity","GICS_SECTOR_NAME"))
about 3x a day, which gets pretty cumbersome. I wanted to write a Public Function to do it, but am not quite sure how.
I tried this way:
and this way:
Neither of which worked. I am stumped. I'm not sure if this is possible or if I'm doing something wrong... Please anyone help?