I need to look for a text value in a list. If it is true then equal a value. If false, look in a different list. If true, return a different value. If false, then return a third value. Is this possible?
Example:
<tbody>
</tbody>
Explanation:
Unsuccessful Search of Column 1 for Cell D1 leads to unsuccsesful search of column 2 = MEAT.
If found in column 1, then Fruit
If found in column 2, then Vegetable
Any ideas?
Thanks in advance
Example:
Apple | Asparagus | T-Bone | Meat | |
Orange | Brussel Sprouts | |||
Grape | Spinach | |||
Banana | Broccoli |
<tbody>
</tbody>
Explanation:
Unsuccessful Search of Column 1 for Cell D1 leads to unsuccsesful search of column 2 = MEAT.
If found in column 1, then Fruit
If found in column 2, then Vegetable
Any ideas?
Thanks in advance