Copy from Two Cells

[Guest]

Hello,

I have two columns, each with a Vlookup to seperate spreadsheets. Each
column will have either a "Y" or and #NA."Y" represnting that a client has
enrolled in a meeting, #NA from Vlookup in either one or both columns if the
client has not enrolled in either meeting.

So I want a third column to have a "Y" if there is a "Y" either coluimn A or
B in the same row.(or conversly a "N" if there is not a Y in either column

Thank you in advance for saving me from pulling anyu more hair out. Help
here is always terriffic.

 

[PCLIVE]

One Way:

=IF(COUNTIF(A1:B1,"Y"),"Y","N")

HTH,
Paul

 

[Guest]

This assumes the ONLY POSSIBLE cell values are Y and #N/A

=if(and(iserror(cell1),iserror(cell2)),"N","Y")

 

[Guest]

=IF(OR(A1="y",B1="y"),"y","n")

 

[Ragdyer]

Try this:

=IF(AND(ISNA(A1),ISNA(B1)),"N","Y")

 

[Guest]

Thank you to all 4 who answered. Problem solved.

Try this:

=IF(AND(ISNA(A1),ISNA(B1)),"N","Y")