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
