I wish to delete the empty rows after finding the common items.Can anyone tell me how to delete the blank rows,so that the common items begin from row 1 itself ?


=IF(ISNA(VLOOKUP(RawMatlIssued!A$2:A$638,PlannedInventoryTransactions!A$2:A$30,1,FALSE)),"",VLOOKUP( RawMatlIssued!A$2:A$638,PlannedInventoryTransactions!A$2:A$30,1,FALSE))