I have subscribers going into one data extension giving a value for a column. For example: data extension name "Foodie" column name "FoodID" with a number in that field, i.e. 1234.
I have another data extension that will have the definition of that value, example: data extension name "FavoriteFoods" columns "FavoriteFood" and "FoodID" indicating i.e. 1234 equals Bananas
I am trying to return the lookup value within an email but nothing is coming through here is my code:
VAR @FF, @FoodID
SET @FoodID = [FoodID]
SET @FF = Lookup("FavoriteFoods", "FavoriteFood", "FoodID", @FoodID)
and I use this: