patrickteo91
Board Regular
- Joined
- Sep 12, 2012
- Messages
- 88
Hi,
I need an excel formula to return a text (Conclusion) if a word is found in either in column K or column M.
Criteria is, if a mixture of Honda and Volvo, to display Honda only. But if both Volvo or both Honda is present, can directly display Volvo or Honda respectively.
I need an excel formula to return a text (Conclusion) if a word is found in either in column K or column M.
Criteria is, if a mixture of Honda and Volvo, to display Honda only. But if both Volvo or both Honda is present, can directly display Volvo or Honda respectively.
Type A | Type B | Conclusion ? |
Honda | Volvo | Honda |
Volvo | Honda | Honda |
Volvo | Volvo | Volvo |
Honda | Honda | Honda |