Classifying Input Data in Excel via "IF" Statement

I am an accountant looking for assistance with a project. I am creating a template for a schedule of items that requires an input sheet, in order to help with the cleanliness of the final table. However, I am having trouble with the last calculation. I need an "if" statement to determine whether the item is either "Cash," "Cash Equivalent," "Short Term," or "Needs Research"(the "if false" value for the entire statement).

Code: =IF(I4='Product Codes'!B7OR(I4='Product Codes'!B8,I4='Product Codes'!B9,I4='Product Codes'!B10,I4='Product Codes'!B11,I4='Product Codes'!B12,I4='Product Codes'!B13),"Cash"and(if(Inputs!I4='Product Codes'!B18or(Inputs!I4='Product Codes'!B19,Inputs!I4='Product Codes'!B20,Inputs!I4='Product Codes'!B21),"Cash Equivilents"and(if(Inputs!I4='Product Codes'!B22or(Inputs!I4='ProductCodes'!B23),"Short-Term","Needs Research"))))"Needs Research")

(The above is a copy of the code that I have been tampering with. I think I have been closer but this is what I have)

In order for the items to reach one of these three classifications, they need to identify with one of five product codes that are listed in another sheet in the workbook. I would like this to be one statement, so that when the data dump comes, all that needs to happen is a copy/paste, and the schedule will be created. Please assist if possible, as any help would be appreciated! Thank you!