I am having difficulty developing a formula that loos up data in two separate
columns and compares answers. Specifically, I need the formula to look at an
entered value, compare the value to an existing data list to see if it is in
the list. I then need the formula to search through a second data list to
find the corresponding value for the first enterable.

EX) If a user enters apple in the "favorite fruit" category, then I want
the formula to scroll through fruit list I have entered in a table on a
separate sheet (bananas, apples, oranges, grapes, pears, prunes,
strawberries). When it finds a value that matches the If statement, I then
want it to look at the point values I have for each of these fruits (bananas
= 5, apples = 4, oranges = 3, etc.) and pull the correct value out of a
separate, corresponding table. Specifically, the fruits are A12:A17 and the
points are C12:C17.

Help???????