Need help getting this to work...
=VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0))
This works now but I want it to excute when a number is place in H12:H13.
So I tried IF(H12:H13>0,=VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0)),"")
But still no luck.. any ideas..Thanks as always
=VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0))
This works now but I want it to excute when a number is place in H12:H13.
So I tried IF(H12:H13>0,=VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0)),"")
But still no luck.. any ideas..Thanks as always