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" wrote in message
...
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.