hi, I'm Dedy .. new in this forum.. my english is pretty bad, so please be nice :)
i have 2 sheets , sheet "Data" as resource and Sheet1
cell Z45 contains vlookup to sheet "Data"
in Sheet1 (cell B45):
="Jonathan "&IF(Z45=1;"wants to eat durian";"doesnt want to eat durian because"...