lookup function
 

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)

lookup function
 

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.

--
Biff
Microsoft Excel MVP


"sim" wrote in message
...
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)