Find word within certain lookup reference

Hi Trowa,
Thanks for your attention to my problem.
I want to put in "General Cost or Travel Expenses" in C1, C2, C3.
I hope you can help me.

Hi gadir_arfan,

What determines what to put in C1, C2, C3?
Is it dependent of the value in column E like (formula in C1)?:
=IF(OR(E1="Electricity",E1="Telephone"),"General Cost",IF(E1="Travel","Travel Expenses",""))

Please clarify why C1 should be General Cost or Travel Expenses.

Best regards,
Trowa

hi trowa,

the logical for C1 :
{ IF in A1 contain word electricity or telephone or travel (etc), vlookup(logical test result,E1:F3,2,false), blank }

Hi gadir_arfan,

Now that I fully understand your query, I'm wondering how many different words are (could be) in column A?

If there are not too many you could use column G (or any other column) to indentify the word that is in column A and then do the logical test in column C based on the values in column G.

Put this formula in column G:
=IF(ISERROR(SEARCH("electricity",A1)),IF(ISERROR(SEARCH("telephone",A1)),IF(ISERROR(SEARCH("travel",A1)),"No results",3),2),1)

Put this formula in column C:
=IF(G1="No results","No results",VLOOKUP(IF(G1=1,"electricity",IF(G1=2,"telephone",IF(G1=3,"travel",""))),$E$1:$F$3,2,FALSE))

Keep in mind that you can hide column G or make its text color white to keep your sheet clean.

Best regards,
Trowa

Hi Trowa,

Your formula works well and in line with my expectations. Actually about ten to fifteen different words, maybe I can split the two in which each section will distinguish five or seven different words.

Thank you very much for your help and success for you Trowa.