If Statement

[Giggzz]

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

 

[Zack Barresse]

For just one number in either cell ..

IF(COUNT(H12:H13)>0,VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0)),"")

For a number in each cell ..

IF(COUNT(H12:H13)=2,VLOOKUP(DATEDIF(B20,$B$4,"y"),EMPLOYEES!$A$32:$G$36,MATCH(B18,EMPLOYEES!$A$31:$G$31,0)),"")

 

[erik.van.geit]

Hi,
instead of H12:H13>0
try this
COUNT(H12:H13)
kind regards,
Erik