You put the Vlookup in B2 and C2.

E.g

=vlookup(A1,Your Table,2,false)
Where
A1 is the lookup value
Your table range is the table of answers
2 is Column 2
False returns a exact match

So if you looked up Cat in A1 it would go to the table and if it found the word cat it would return what is in Col 2 of the table

VBA Noob