Paste data based on a value

[rmac23]

I have a spreadsheet with 2 columns of data; I wrote a MATCH formula to find the matches, then a simple IF statement to find those matches (not just the row number at which the match is located).

I need to find all matches and paste that data to one column, but do that 3x, as such:

• ColumnA = Y ColumnB = Y
• ColumnA = N ColumnB = Y
• ColumnA = Y ColumnB = N

I'm pretty good with Excel, but limited in VBA skills, so need some help...and fast