Keyword search within a single cell mixed with vlookup

Originally Posted by ndube50

Hi,

Thanks for your prompt reply.

Can you elaborate a bit on where I would insert this part of the statement into the function?

Here is the function as it currently exists:
=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH($AQ$34:$AQ$67,F6)),$AR$34:$AR$67),IFERROR(VLOOKUP(E6,Toggles!$S:$Y,4,FALSE),"Not Defined"))

thx

I may have forgotten to include the attachment.
If so, here it is again.