IF column A contains ANY text OR IF column B contains ANY text..
Closed
Pete
-
Mar 6, 2016 at 08:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 8, 2016 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 8, 2016 at 11:26 AM
Related:
- IF column A contains ANY text OR IF column B contains ANY text..
- Vba find column by name ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Sum column if another column equals ✓ - Excel Forum
- Excel find similar text in two columns - Guide
- If column contains value then return value in another cell ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Mar 8, 2016 at 11:26 AM
Mar 8, 2016 at 11:26 AM
Hi Pete,
You mean something like this?:
=IF(COUNTIF(A:A,"*")>0,"XYZ",IF(COUNTIF(B:B,"*")>0,"ABC",IF(COUNTIF(C:C,"*")>0,"QRS",IF(COUNTIF(D:D,"*")>0,"TUV",IF(COUNTIF(E:E,"*")>0,"DEF")))))
Best regards,
Trowa
You mean something like this?:
=IF(COUNTIF(A:A,"*")>0,"XYZ",IF(COUNTIF(B:B,"*")>0,"ABC",IF(COUNTIF(C:C,"*")>0,"QRS",IF(COUNTIF(D:D,"*")>0,"TUV",IF(COUNTIF(E:E,"*")>0,"DEF")))))
Best regards,
Trowa