I have written the following formula that is working fine for column L in my spreadsheet.
(IF(ISNUMBER(FIND("Opening",L54)),"OPENING",IF(ISNUMBER(FIND("BIA",L54)),"BIA",IF(ISNUMBER(FIND("AICF",L54)),"AICF",IF(ISNUMBER(FIND("LASKIN",L54)),"LSKN",IF(ISNUMBER(FIND("OTHER",L54)),"OTHER",IF(ISNUMBER(FIND("PELL",L54)),"PELL",IF(ISNUMBER(FIND("SDEA",L54)),"SDEA",IF(ISNUMBER(FIND("SEOG",L54)),"SEOG",IF(ISNUMBER(FIND("TRIBAL",L54)),"TRIBAL",IF(ISNUMBER(FIND("VA",L54)),"VA",IF(ISNUMBER(FIND("Cafe",L54)),"CAFE",IF(ISNUMBER(FIND("AIHEC",L54)),"AIHEC",IF(ISNUMBER(FIND("MEAL",L54)),"MEAL",IF(ISNUMBER(FIND("SERF",L54)),"SERF",IF(ISNUMBER(FIND("Rental",L54)),"RENTAL",IF(ISNUMBER(FIND("IHS",L54)),"IHS",IF(ISNUMBER(FIND("Donation",L54)),"DONATION",IF(ISNUMBER(FIND("refund",L54)),"REFUND",IF(ISNUMBER(FIND("Dacotah Bank",L54)),"DACOTAH BANK",IF(ISNUMBER(FIND("meal",L54)),"MEAL",IF(ISNUMBER(FIND("UST-",L54)),"UST",IF(ISNUMBER(FIND("GED",L54)),"GED TESTING",IF(ISNUMBER(FIND("Summer Reading",L54)),"LIBRARY",IF(ISNUMBER(FIND("Vehicle",L54)),"VEHICLE",IF(ISNUMBER(FIND("BOT",L54)),"BOT",IF(ISNUMBER(FIND("Employee",L54)),"EMPLOYEE",IF(ISNUMBER(FIND("PR DEDUCT",L54)),"EMPLOYEE",IF(ISNUMBER(FIND("CAFE",L54)),"CAFE",0)))))))))))))))))))))))))))))

BUT... .now I would like to add a piece that will add IF(ISNUMBER(FIND("Voucher",L54)) move to column P and perform the formula above on column P.

I have both formulas in a separate worksheet because I had read somewhere that we could do it that way but don't know the formula doing that way.

How do I add this last step and is there and easier way to do this on a separate spreadsheet using a table format