Avoiding Copy & Paste in Hidden/Filtered Cells

I have a spreadsheet that I have hidden / filtered out data from a previous Vlookup. The only data I wish to apply is the additional to the unhidden / unfiltered rows that are currently blank or show a #N/A. But when I copy and paste the equation down all the unhidden / unfiltered rows the hidden / filtered rows are changed picking up the new additional data. How do I work around this?

Thank You.