Vlookup with if condition

[faraz502]

Dear Sir,
I have a sheet with This format.

I Need Site Code data against employee ID and also match.

I Used this formula but not working.
=IF('Attendance Details'!$B:$B=$W5,IF('Attendance Details'!$A:$A=X$4,VLOOKUP($W5,'Attendance Details'!$B:$F,5,)))

 

[Saurabhj]

Hi, Use Index match.

=INDEX($F:$F,MATCH(1,($W5=$B:$B)*(X$4=$A:$A),0))

 

[faraz502]

Hi, Use Index match.

=INDEX($F:$F,MATCH(1,($W5=$B:$B)*(X$4=$A:$A),0))

Thanks A Lot sir.

 

[Saurabhj]

My Pleasure and thanks for the feedback.