So i'm trying to extract data from bloomberg,however, one particular problem i keep running into is financial firms. because unlike say retail firms, bloomberg doesnt have a "current assets" for financial firms.

Under CERTAIN financial firms, like banks, financial services and capital markets, the equivalent of current assets is cash and short term investments

I'm trying to write a one-size-fits-all excel command for this.

If the sector (using lookup or search) is identified as one of the above, then link to cash and st investments, IF NOT identified as a financial firm, then link to current asset value.

This is what my command looks like and there must be a more efficient way to do this:
=IF(E18="Financials", IF(ISNUMBER(SEARCH("Bank",F18)), BDP(B18, "cash_and_st_investments"), IF(ISNUMBER( SEARCH("markets",F18)), BDP(B18, "cash_and_st_investments"), BDP(B18,"bs_cur_asset_report"))), BDP(B18,"bs_cur_asset_report"))

It works for now, but i now have a new search criteria. "services".

What I am trying to do is an IF statement, that tries to search if a F-cell (industry names) matches or contains one of the words. If F-cell column contains words "bank", "markets" and "services" then return the cash_and_short term investments. Otherwise, just refer to current asset.

I dont want to expand this existing command or without using VBA.

Please help :'(