Forum Discussion
Solved
A formula that labels all convenience stores.
Hi There, this is my first post. Using Office 365 and a fairly new, but excited, Excel user. 🙂 I'm trying to make a smart excel sheet to keep track of my economy and I immediately ran into at pro...
As variant you may create helper range as on the left
and return category by
=INDEX( $C$3:$C$7, XMATCH(TRUE, ISNUMBER( SEARCH($B$3:$B$7, E3) ) ) )
As variant you may create helper range as on the left
and return category by
=INDEX( $C$3:$C$7, XMATCH(TRUE, ISNUMBER( SEARCH($B$3:$B$7, E3) ) ) )Thanks the formula works perfect.
But what if I want to make things a bit easier for my self by having all categories listed in a row and all transactions listed underneath? Like in this picture. I tried the =SEARCH function on the whole table but the problem is that it returns "1" for all the blank cells also.
Is there a function that ignores blank cells so that I can search for Mc Donalds and return the tekst "Junkfood"??
Regards Kasper
