vLookup Problem never ceases
Dear someone
Im having a problem with a vlookup formula, with (last cell/row always
varying) what do I do to copy the last cell with data and paste it to another
sheet.
This formula below finds the first sum not the last.
Or Is there another way to copy last cell with data and paste to another
sheet?

=IF(ISNA(VLOOKUP(A5,Employee1!$A$5:$AF$32,32,FALSE )),"",VLOOKUP(A5,Employee1!$A$5:$AF$32,32,FALSE))