Hello from Steved

=IF(ISNUMBER(MATCH(--B2,Staff!$A$2:$A$2000,0)),VLOOKUP(--B2,Staff!$A$2:$C$2000,2,0)&CHAR(10)&VLOOKUP(--B2,Staff!$A$2:$C$2000,3,0),"")

Every day I have to copy the above formula to a new worksheet ( 700 Rows )

If the above is possible I will use the same worksheet every day, just
updating the previous day Worksheet, hence I will nolonger have to input the
formula..
Thankyou.