Forum Discussion
Vlookup +
I would like to keep track of my finances and have downloaded my bank statement to an excel workbook the sheet is called accounts I have also produced a sheet (codes) where I have found the common s...
Hi Robert,
That could be
=IFNA(INDEX(codes!$B$2:$B$1900,MATCH(1,INDEX(ISNUMBER(SEARCH(codes!$A$2:$A$1900,C2))*1,0,0),0)),"")
It returns zero if the code is not found, for example you have code for
CARD PAYMENT TO TESCO STORES but no code for CARD PAYMENT TO TESCO STORE
Attached.
That's excellent
Thanks so much
Rob
Thanks so much
Rob