sameeragarwal

If(and(employee name,one of the joined dates),Actual salary criteria for this employee,and(employee name,other joined date),Actual salary criteria for this employee,vlookup(...))

or

You add a new column at the beginning which combines the employee name and joined date and then do a lookup based on that column.