I have a rota on sheet one and a costs table on sheet 2. Sheet 2 currently grabs data from sheet one and it all works great

Colum A1 grabs name and colum Z1 grabs costs. for all my staff it works good but i have supervisors that are on salery, i need z1 to report a cost of 350 but only if there is a name in colum a1. any way i can do this?

thanks