How to find attendance data for particular date

[webmax]

Hi

kindly find the attached find and help the formula how to find the data from the above table for the particulars emp code with Date

Regards
Shahul

 

[Deepak]

=INDEX($B$2:$K$19,MATCH(B22,$B$2:$B$19,0),MATCH(C22,$B$2:$K$2,0))

 

[vletm]

@webmax
for D22 =VLOOKUP(B22,B$3:K$19,MATCH(C22,B$2:K$2,0))
and copy down

 

[Syedali]

@webmax
for D22 =VLOOKUP(B22,B$3:K$19,MATCH(C22,B$2:K$2,0))
and copy down

VLOOKUP(B22,B$3:K$19,MATCH(C22,B$2:K$2,0),0)
,0 should come.

 

[vletm]

@Syedali - Info for You:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
range_lookup is A logical value that specifies whether you want this function to find an exact match or an approximate match.

• If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
• If FALSE, this function will find an exact match. If one is not found, the error value #N/A is returned

 

[Deepak]

vletm,

But here! we are looking for exact match not approximate. In real data this may encounter with wrong result where incrementing emp code is missing.

 

[vletm]

@Deepak
You are right too.
Then it should add FALSE in the end of VLOOKUP not 0.
Check Replys #4 & #5.

 

[Syedali]

@Syedali - Info for You:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
range_lookup is A logical value that specifies whether you want this function to find an exact match or an approximate match.

• If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
• If FALSE, this function will find an exact match. If one is not found, the error value #N/A is returned

No if without zero means for me different value coming. So only i posted

 

[Syedali]

@Deepak
You are right too.
Then it should add FALSE in the end of VLOOKUP not 0.
Check Replys #4 & #5.

Zero means false only...

 

[vletm]

@Syedali
I have tried to use ONLY parameters that Function's Syntax has,
as I wrote with #5 Reply.
Maybe, there are more possibilities ... and some depends which Excel-version You use ...

 

[Syedali]

@Syedali
I have tried to use ONLY parameters that Function's Syntax has,
as I wrote with #5 Reply.
Maybe, there are more possibilities ... and some depends which Excel-version You use ...

OK 0=FALSE 1=TRUE

 

[Deepak]

@Deepak
You are right too.
Then it should add FALSE in the end of VLOOKUP not 0.
Check Replys #4 & #5.

Dear,

As Syedali already pointed.

Here 0 is equivalent to FALSE and 1 to TRUE.

 

[Syedali]

Dear,

As Syedali already pointed.

Here 0 is equivalent to FALSE and 1 to TRUE.

Ok. I overlooked....