lookup function

[sim]

If B5 matches a text in columb C, show answer in cell E5 from columb D in
same row.

DESCRIPTION FILE CATEGORY RESULT
sandy marks (B5) "*tom sanders*" EVANGELIST ELECTRICIAN
dave marks "*Mom*" HOUSE WIFE (ANSWER)
marks "*DAVE*" TRAFFIC CONT.
tom sanders "*sandy*" (MATCH) ELECTRICIAN (DATA NEEDED)

 

[T. Valko]

It's not real clear what you're trying to do.

Can't tell what your data looks like with that sample. Try reposting your
sample data but use something like commas to separate the columns from one
another.