Search a column for up to 30 words then insert a different word in a separate column

Okay, look at this example.
I added Sheet2 which has Table1 with Name/Chemical/EPA Number

On Sheet1, D1, I put this formula. It looks for the value in C1 in Table 1 Column A. If it finds it, it returns the value in the same row in Col B. Copy that formula all the way down the data page.

=IFERROR(VLOOKUP(C1,Table1,2,FALSE),"")

In E1 is a similar formula but returning the value from the 3rd column (C)

=IFERROR(VLOOKUP(C1,Table1,3,FALSE),"")
Are you looking for something like that to work with?