Hi, I'm trying to get to grips with the index and match functions working in conjunction, as I need to find a result based on two criteria. I thought I'd written the code right, but its returning the wrong field?
I've attached a sample file - the information in cell Q2 is wrong, and should display (as I'm guessing you can work out from the formula), the description that corresponds to an ISIN of GB0000566504 and a TD Quantity of -16034. If someone could tell me what I've been doing wrong, that would be wonderful.
Thanks in advance.
CFD Reconciliation File.xlsm
Bookmarks