vlookup multiple values need assistance

[Killerking]

Hi I need help with this
on the sheet2 have a start date and end date employee name and leave type
on sheet1 I have dates in coulomb b3 to af3 and employee name in a3 I need to lookup the leave type for that specific date
on sheet3 I have the days that the employee was Present

I got this far I need Help FX=IF(AND(VLOOKUP($A$2,Sheet3!$A:$C,3,0)="Present",IFNA(VLOOKUP(Sheet1!C$1,Sheet3!$B:$C,2,0),FALSE)="Present"),"Present","HELP")

 

[bosco_yip]

Maybe,

In "Sheet 1" B2, formula copied across :

=IFERROR(LOOKUP(1,0/(Sheet3!$A$2:$A$500=$A2)/(Sheet3!$B$2:$B$500=B$1),Sheet3!$C$2:$C$500),"Help")



Regards

 

[rahulshewale1]

Hi @Killerking ,

See if is ok ?

Regard
Rahul Shewale

 

[Killerking]

Hi @Killerking ,

See if is ok ?

Regard
Rahul Shewale

thanks this will help