lookup function

  • Thread starter Thread starter sim
  • Start date Start date
S

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)
 
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.
 
Back
Top