Try this formula with this layout

in C2 and copy down

=IFERROR(LOOKUP(25^25,SEARCH($D$2:$D$4,A2),$E$2:$E$4),"")

Row\Col
A
B
C
D
E
1
 Details Sum Category Look Ups Returns
2
 VISA Mc Donalds -130,00 Lunch Mc Donalds Lunch
3
 138766 Statoil -640,00 Gas Statoil Gas
4
 76234 TAXI 20141127 -357,00 BurgerKing Lunch
5
 23454 BurgerKing -130,00 Lunch