Put the filter in existing excel and populate the cell with values

In this excel first we have to put filter in L column to get empty values and then we have to put filter for column A for non empty values then finally we have to take L1 cell value its a vlookup formula we have to put in all the empty cell of column L