I have a cell with the following formula

=VLOOKUP(Sheet1!A14,Sheet3!A5:Sheet3!K150,11,FALSE)

If Sheet1!A14 is not present on Sheet3! I will get an #N/A error. I have another cell on a summary sheet that returns the data from the above formula. In order to clean up the summary sheet I only want data returned, if #N/A is a result of the formula I do not want any info on the summary sheet. I tried the following formula but it did not work, is there another way to do it?

=IF(P12="#N/A","",P12)

My hope was that I could replace #N/A with ""