Hi everyone
Have been pulling my hair out. I've exported my bank transactions for the year.
Col F contains the list of transactions ie
Loan Repayment, McDonalds, Target, Smith's Pharmacy. Each row has a long description of the transaction name eg "EFTPOS 20/07 17:39 MCDONALDS"
I have a range called "Uniques" with 2 columns of information (several rows).
If the word "McDonalds" appears anywhere in F2, I want the formula to lookup the range Uniques" and then return a value. In my eg, the word "Takeaway".
I've been working on one forumla based on a previous thread, F1053 is the first cell in the range. Of course all my cells are returning the word apple
but excel does not show any errors with the formula. I suspect Match(True is wrong.
=IF(OR(ISNUMBER(FIND(Uniques,H1059))), INDEX(Uniques,MATCH(TRUE,(ISNUMBER( FIND(Uniques,H1059))),0)),"apple")
Thanks in advance.
Stef
Have been pulling my hair out. I've exported my bank transactions for the year.
Col F contains the list of transactions ie
Loan Repayment, McDonalds, Target, Smith's Pharmacy. Each row has a long description of the transaction name eg "EFTPOS 20/07 17:39 MCDONALDS"
I have a range called "Uniques" with 2 columns of information (several rows).
If the word "McDonalds" appears anywhere in F2, I want the formula to lookup the range Uniques" and then return a value. In my eg, the word "Takeaway".
I've been working on one forumla based on a previous thread, F1053 is the first cell in the range. Of course all my cells are returning the word apple
but excel does not show any errors with the formula. I suspect Match(True is wrong.=IF(OR(ISNUMBER(FIND(Uniques,H1059))), INDEX(Uniques,MATCH(TRUE,(ISNUMBER( FIND(Uniques,H1059))),0)),"apple")
Thanks in advance.
Stef
