Thread: lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sim Sim is offline
external usenet poster
 
Posts: 9
Default 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)