Index/Match Formula
I think an index/match formula will solve your problem.
Here's a sample of the formula using a simple list with column B showing the formula:
COLUMN A COLUMN B COLUMN C
Corn =INDEX(C:C,MATCH(A2,C:C,0)) Syrup
Carrots =INDEX(C:C,MATCH(A3,C:C,0)) Eggs
Syrup =INDEX(C:C,MATCH(A4,C:C,0)) Butter
Eggs =INDEX(C:C,MATCH(A5,C:C,0)) Milk
Butter =INDEX(C:C,MATCH(A6,C:C,0)) Chocolate
The results will look like this. The #N/A error message will indicate that there was no match for that item. Just copy/paste the formulas as values after and use the find/replace to get rid of the #N/A's.
COLUMN A COLUMN B COLUMN C
Corn #N/A Syrup
Carrots #N/A Eggs
Syrup Syrup Butter
Eggs Eggs Milk
Butter Butter Chocolate
Hope this helps,
Keith