Good day,
As per the attachment i require a formula that would pull data from 1 column (Lender daily billing) based on if it has data in the "Sec lending detail" column.
The Lender daily billing column only has the share name and fee value whereas the Sec lending detail column has the portfolio , share , valuation and %
The Fee Split column needs to detect which shares has fees and return the Portfolio/Share/Valuation/%.
I've tried a variation and combination of INDEX/MATCH and IF formulas but nothing seems to work correctly.
Any help would be appreciated.
Bookmarks