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.

One Way:

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

HTH,
Paul


--

"Steve B" <(E-Mail Removed)> wrote in message
news:57572D8C-1CD2-467F-8FF5-(E-Mail Removed)...
> 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.

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

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

"Steve B" wrote:

> 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.

=IF(OR(A1="y",B1="y"),"y","n")
--
Gary''s Student - gsnu200738


"Steve B" wrote:

> 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.

Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Steve B" <(E-Mail Removed)> wrote in message
news:57572D8C-1CD2-467F-8FF5-(E-Mail Removed)...
> 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.

Thank you to all 4 who answered. Problem solved.

"Ragdyer" wrote:

> Try this:
>
> =IF(AND(ISNA(A1),ISNA(B1)),"N","Y")
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "Steve B" <(E-Mail Removed)> wrote in message
> news:57572D8C-1CD2-467F-8FF5-(E-Mail Removed)...
> > 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.
>
>
>