I assumed the column F: Type is in the Lookup_Table....

Also that you are looking for the word Type in column F in order for it to be a match....