Parsing a Bloomberg generated array.

[wdennis]

Is it possible to do INDEX MATCH on an array that has not been exposed? I will like to import array data from Bloomberg but input the array straight into the INDEX MATCH formula without exposing the array on another excel sheet.

Also, what extra syntax must a Bloomberg formula have to be able to achieve the above since the Bloomberg seems the alien in the formula.

Thank you.