IF column A contains ANY text OR IF column B contains ANY text..

Question

IF column A contains ANY text OR IF column B contains ANY text..

[Closed]

Report

Pete - Mar 6, 2016 at 08:45 AM
TrowaD

Posts: 2779
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 29, 2021

- Mar 8, 2016 at 11:26 AM

Hello,

I'd like to achieve in Open Office Calc

IF column A contains ANY text then ADD "XYZ" into cell G12 OR
IF column B contains ANY text then ADD "ABC" into cell G12 OR
IF column C contains ANY text then ADD "QRS" into cell G12 OR
IF column D contains ANY text then ADD "TUV" into cell G12 OR
IF column E contains ANY text then ADD "DEF" into cell G12.

Thanks very much

Open Office Calc

If cell contains any text then
Excel partial match two columns - How-To - Excel
Tweetdeck column width - How-To - Internet
Vba find column by name ✓ - Forum - Excel
Excel data validation list from table multiple columns - How-To - Excel
Excel column index to number - How-To - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-03-08T11:26:40-0500

Answer 1 / 1

TrowaD

Posts: 2779
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 29, 2021

468
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

IF column A contains ANY text OR IF column B contains ANY text..

1 reply

Your reply

Subscribe To Our Newsletter!