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.