One Way:

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

HTH,
Paul


--

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