IF (ISNUMBER formula with a Range

[jamstar]

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

 

[alow]

So you have your descriptions in Column F and you wsant to pull out what's in column H if the word McDonalds is in Column F, right?