How to create nested IF-statements with multiple criteria (lookup multiple columns)?

I am trying to create one long formula with multiple criteria. Basically:

C1=

IF Sheet1!A1 contains "Fruits", THEN look for correspondent value in Sheet2!N:N or Sheet2!R:R based on product number in Sheet1!F1.

IF Sheet1!A1 contains "Clothes", THEN look for correspondent value in Sheet2!X:X or Sheet2!AC:AC based on product number in Sheet1!F1

IF Sheet1!A1 contains "Other", THEN put text "Other"

Is it even possible to include all these criteria into one formula? Thank you for your help!