using IF(ISNUMBER(SEARCH formula

I am trying to figure out how to accomplish the following formula.

Formula in K2, will look at Cell E2 and if E2 contains "general merchandise" then look at C2, and if C2 contains "QT" (true) put "FUEL" and if C2 does not contain "QT" (false) put value of E2.

I use a similar to find text values and enter new value but i want compare with another cell before ...

here is the formula i use but need to add variable of another cell to compare to...

=IF(ISNUMBER(SEARCH("USAA FED*",C22)),"Mortgage",IF(ISNUMBER(SEARCH("SHELL*",C22)),"AUTO FUEL",IF(ISNUMBER(SEARCH("OFFICE DEPOT*",C22)),"Office Supplies",IF(ISNUMBER(SEARCH("INGLES*",C22)),"Groceries",IF(ISNUMBER(SEARCH("AMAZON*",C22)),"Internet Purchases",IF(ISNUMBER(SEARCH("*Manley, R*",C22)),"Transfer to Canon",IF(ISNUMBER(SEARCH("*HOLY RED**",C22)),"Education",IF(ISNUMBER(SEARCH("*PUBLIX*",C22)),"Groceries",IF(ISNUMBER(SEARCH("*TRADER JOE*",C22)),"Groceries",IF(ISNUMBER(SEARCH("*dillard*",C22)),"Department Store",C22))))))))))

Thanks Dave

Hi and thanks for the reply's.I tried the LOOKUP approach plugging in my values and it returned a #REF. Here what I tried.
=CHOOSE(MATCH(C3,{"USAA FED*","*HOLY RED*","HEWLETT PACK*","GLIC","*GRANT*"},E3),"Mortgage","Education","Deposit HP","Deposit Insurance","Student Loan")

Maybe i didn't explain what i was trying to do very well. I am taking bank data and doing a budget pivot table. Column C header is "original description". Column E header is Catagory. Some entries in catagory are "unassigned" and i want to identify all give them a description I can catagorize in te pivot table. Also there are many different unassigned "original descriptions".

So in F2 i want a formula, that looks at cell E2, if it is "unassigned" then look at C2, and if it says "HRCS" put "Education is F2, if it says USAA FED*" put "mortgage" in F2, etc.

Thx
DM

For match function you can use

=MATCH("*"&C3&"*",{"USAA FED*","*HOLY RED*","HEWLETT PACK*","GLIC","*GRANT*"},0)

I got it to work , but now trying to group SEARCH(find-text .... It worked if i use only (1) value for example ....
IF(ISNUMBER(SEARCH("XXX",C1545)),"XXXX",E1545)

I group several find_values using { } below but it returns C1545 instead of ARGON, GLIC ... depending

,IF(ISNUMBER(SEARCH({"AEGON","Assurity*","*GLIC*"},C1545)),"Deposit Insurance",IF(ISNUMBER ....

Sorry, I do appreciate the help and suggestions. I tried post #3 and tried to make it work but could not figure it out. Also my file had a lot of confidential banking info, however i have made it more generic in order to share. See attached simplified file. there are many more entries in my file.

for example; there are multiple unique entries that I want to call Education in Column F. Current they are seperate entries. Is there a way to group them is a look_up value?

Also I do not see how to post/upload the file?

From Forum FAQs

How do I attach a file to a post?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

I have uploaded the file, are you able to see it? Also as mentioned, i was able to get the results I wanted using the following formula. As mentioned i want to be able to have multiple "find_text" conditions so I don't have to have so many IF statements. Is that possible with this type of formula?

=IF(ISNUMBER(SEARCH("USAA FED*",C2)),"Mortgage",IF(ISNUMBER(SEARCH({"HOLY*","GRANT"},C2)),"Education",IF(ISNUMBER(SEARCH("Hourly",C2)),"Deposit CTG",IF(ISNUMBER(SEARCH("AEGON",C2)),"Deposit Insurance",IF(ISNUMBER(SEARCH("Assurity*",C2)),"Deposit Insurance",IF(ISNUMBER(SEARCH("*GLIC*",C2)),"Deposit Insurance",IF(ISNUMBER(SEARCH("HEWLETT",C2)),"Deposit HP",IF(ISNUMBER(SEARCH("GRANT",C2)),"Education",IF(ISNUMBER(SEARCH("WIRE TYPE",C2)),"Deposit - Edward Jones",IF(ISNUMBER(SEARCH("CHEVRON",C2)),"Gasoline/Fuel",IF(ISNUMBER(SEARCH("XXX",C2)),"XXXX",IF(ISNUMBER(SEARCH("XXX",C2)),"XXXX",IF(ISNUMBER(SEARCH("XXX",C2)),"XXXX",E2)))))))))))))