Lookup Value from different Sheet

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

Dear Dilip,

Thanks for notifying that. Shall we have "-" instead of "~". or any sign will cause problem.

Or anything else, because, I have to show that for year duration, please suggest any other way to mark that.


Regards,
Kunal Kumar

Originally Posted by [email protected]

Dear Dilip,

Thanks for notifying that. Shall we have "-" instead of "~". or any sign will cause problem.

Or anything else, because, I have to show that for year duration, please suggest any other way to mark that.


Regards,
Kunal Kumar

You try this code, in cell D4

=INDEX(Sheet2!$A$2:$Y$5,MATCH(LEFT(D$3,1)&"~~"&RIGHT(D$3,2);Sheet2!$A$2:$A$5,0);MATCH(Sheet1!$B4,Sheet2!$A$1:$Y$1,0))