Excel string match -

i have 2 tables me

img http://i62.tinypic.com/mrcqw5.jpg

i need compare "column c" values in table a, against "column f" values in table b , fill "column d" "column g" values if match found.

for example "column c" in table needs scanned "keells" (in table b) , if match found adjacent cell in "column d" needs filled value "grocery" adjacent value of "keells".

table b should able populated different entries too. if column c has "phrases" has no match against "column f" values need filled other.

in cell d3 use formula , drag down.

=iferror(vlookup(left(c3,(find(" ",c3,1)-1)),f2:g10,2,0),vlookup(left(c3,(find("-",c3,1)-1)),f2:g10,2,0))