If two different cells not equal to a text value display the text value in a different

[rdoulaghsingh]

I have two cells A1 and B2 which contain the default text<Customer Name>. If either of the two cells (one or the other) contain anything other than "<Customer Name>" I want the text to be displayed in another cell K14.
Below is the excel function I have in K14, but I'm missing something. I tried using the OR operator as well, but that doesn't give me the correct output either. I'm also wondering if there is an additional syntax I can add to the function so if one of the two cells with <Customer Name> gets deleted, it doesn't give an #REF! error. Please help!

=IF(AND(A1<>"<Customer Name>",B1<>"<Customer Name>"), A1, B1)

 

[jtakw]

Is it possible to retain column B also if column A is deleted instead of showing blank?

Since we're only dealing with 2 cells, we can use the Volatile function INDIRECT without any performance issues:

=IFERROR(IF(A1<>"<Customer Name>",A1,IF(B1<>"<Customer Name>",B1,"")),INDIRECT("a1"))

 

[rdoulaghsingh]

Since we're only dealing with 2 cells, we can use the Volatile function INDIRECT without any performance issues:

=IFERROR(IF(A1<>"<Customer Name>",A1,IF(B1<>"<Customer Name>",B1,"")),INDIRECT("a1"))

Many thanks for your support!

 

[jtakw]

You're welcome, thanks for the feedback.

 

[rdoulaghsingh]

You're welcome, thanks for the feedback.

Sorry to be a bother. I tried the function as shown below, but when the page with the one of the cells gets deleted it still gives Ref error. Any parting pointers?

=IFERROR(IF('Introduction 800-171'!B15<>"<Customer Name>",'Introduction 800-171'!B15,IF('Introduction CMMC'!B15<>"<Customer Name>",'Introduction CMMC'!B15,"")),INDIRECT('Introduction 800-171'!B15))

 

[jtakw]

My solution in Post #11 works if the 2 cells in question are on the Same sheet And Next to each other, as you described.
The formula as it is, will Not work if the 2 cells are in Different sheets.

Since you started a new thread, I'll post my answer there.