Vlookup formula returns with False Result, How can I get the exact value ?

Hi,

I have been trying my best to get the activity code for each worker for each weekday. the formula is looking for the values ( activity codes) in another tab called TK_DB and in this tab there is data for the whole week showing the activities done by the workers but not as groups not individuals. the formula is showing the exact value for only one day to track the daily performance of each worker against his activity. I have attached the file for your reference. the problem i'm facing is that the formula is working perfect for only the first day of the week and then it returns FALSE which is a big question mark in my head and I can't find answer for it.


Thank you in advance.


Midoya

Hi Guys,

Thank you for your quick replies. I'm re-attaching the file but unfortunately, its size is 1.3 MB and hence it not possible to upload it. if any one has e-mail , I can send it to him.

Midoya

130110 - DPR Checker (V07 8)_NO REWORK _Yahia.zip

here it is

Hi vlady,

Thanks alot for your answer and quick reply . It's working woth me but I think the formula is only tracking same activity of first day and it's the same in 2nd day. in other words, I have changed the activity code for emp.#59311 in the second day in TK_DB tab to make sure that it is working but it is not changing however code was changed.

The second option ( formula) is not clear enough for me as you typed it :
=index($I$2:$I$3000,match($g$2&B5,TKB_DATE&EMPNUMBER,0)) -ctrl+shift+ente

I don't understand the last part of your formula [ - Ctrl+Shift+entre]

Thank you

Midoya

yeah but it gave me #NAME?

Hi there

I have named the range already please see the formula below

=INDEX(TKDB_Act1Code,MATCH($M$2&B5,INDEX(TKB_DATE&TKDB_CompNo,0),0))

again it gave me #N/A

please note that "TKDB_Act1Code" refers to activity code which you typed "$I$2:$I$3000" in the above formula and "TKDB_CompNo" refers to "EMPNUMBER"

Midoya

130110 - DPR Checker (V07 8)_NO REWORK _Yahia.zip130110 - DPR Checker (V07 8)_NO REWORK _Yahia.zip

I have attached the sheet again after fixing the formula in post#13. Please review and kindly advise me. Thank you.

Midoya

Hi there,

Still I'm waiting for your help with the above formula.

Thank you in advance

Midoya

=IFERROR(IF(AND(MATCH($M$2,TKDB_Date,0),(MATCH(B4,TKDB_CompNo,0))),(VLOOKUP(B5,TK_DB!$B$2:$U$3000,8,FALSE)),""),"")

Guys,

Thank you so much it's working perfectly with me without any problems. Appreciated.

Midoya