Dear Seniors and all members,
I am here again and required your assistance. Actually I got stuck with my work regarding the lookup value function.
I am trying to compile a sheet, where I need data according to Year wise as I mentioned 0~2 and Skill wise. I tried using =VLOOKUP($D$3,Sheet2!$A$2:$Y$5,MATCH($B4,Sheet2!$B$1:$Y$5,0)+1,FALSE)
But this is not giving me output.
Attaching file for your reference, kindly advise me to correct this formula.
Regards,
Kunal Kumar
Bookmarks