VLOOKUP, SEARCH and IF

Dear Forum,

I have a worksheet with one column which contains alphanumeric data, with spaces etc.

Currently I have a nested IF statement pasted into column B, which searches the respective cell in column A for certain words and depending on these words enters a value into column B.

Below is a sample of my unwieldy IF statement.

IF(ISNUMBER(SEARCH("spade",A2)),"TOOLS",
IF(ISNUMBER(SEARCH("fence",A2)),"FENCING",
IF(ISNUMBER(SEARCH("seat",A2)),"FURNITURE",
IF(ISNUMBER(SEARCH("fork",A2)),"TOOLS",
""
)
)
)
)

If anyone can help to make my IF statement less complicated to manage it would be awesome.

I've been trying to produce a separate worksheet with all the search words and values, but not sure how to get it working. Or maybe my approach is wrong altogether?

Any recommendations well appreciated.

Cheers,
KFCI