I am trying to figure out what is the formula that will work with the scenario I am looking for.
Worksheet 1 - list full of foods: 1) Column “title” of the food and 2) Column named as “Is this food spoiled” with answer Yes or No.
Worksheet 2 - list of weakness: 1) Column “title” of the food (same as Worksheet)
Since the list of foods already identified which food is spoiled or not. The list of weakness does not have the information which food is spoiled or not. I would like to add “Is this food spoiled” on the new column for Worksheet 2 gets the information from Worksheet 1.
Let's assume you have Sheet1 and Sheet2. Both sheets have 'Title', Banana' and 'Apples' entered in A1:A3. Sheet1 has got 'Yes' and 'No' in B2:B3. You can use the following formula in Sheet2!B2 to lookup for a value matching 'Banana':