Create new data column from 2 different word lists

[IWLTJONP]

Hi,
let's say I have data in columns A-B, and a target list in C:

A B C
dog 21 dog
cat 43 mouse
mouse 21 lion
puppy 45
lion 23

What I need is a way to search column A for each word in Column C, and if found, to print out this data to another column (or worksheet), like this:

D E
dog 21
mouse 21
lion 23

If anybody knows C, I have a script to do exactly this, but I can't figure out how to do it in excel (I'm useless with VB). Please Help me increase productivity in my PhD studies!

 

[Gerald Higgins]

Well to duplicate the values in Col C into Col D, it looks like you can simply use this in D1

=C1

and copy down as far as required.

However, maybe you want something more complicated - if it is possible for a value to appear in Col C but NOT APPEAR in Col A, then do you want such a value to appear in Col D ?
If yes, post back and we can do that.

Then, to look up the corresponding values from Col B, use something like this

=vlookup(d1,a$1:b$5,2,false)

and again, copy down.

 

[PCL]

Perhaps next formulaes could help:
in D1 =IF(NOT(ISERROR(MATCH(C1,A$1:A$20,0))),INDEX(A$1:A$20,MATCH(C1,A$1:A$20,0)),"")
in E1 =IF(NOT(ISERROR(MATCH(C1,A$1:A$20,0))),INDEX(B$1:B$20,MATCH(C1,A$1:A$20,0)),"")

 

[IWLTJONP]

Gerald, I have words that appear in A but do not appear in C--not vice versa. The final result should be the same format as columns A-B, but shorter, since I only include the words from C.
PCL, I'll try those formulae as well.
Thanks!