Excel IF Function

I am trying to extract text from a worksheet within the same workbook to create a summary worksheet. In using the below formula, if the reference cell is not on the same row in both worksheets, the formula stops working on that respective row and all below rows. How can I correct this?

=IF(‘CIV-VACANT DETAIL’!$D:$D=$D15,’CIV-VACANT DETAIL’!$J:$J,””)