Changing Col_Index_Num using Vlookup

Dear All,

Need to know, if we use =+VLOOKUP($F$7,Sheet1!$C$2:$J$25,4,FALSE)


need to change Col_Index_Num. Kindly post the suggestions if this is possible...

Attaching file for better understanding, see the yellow highlighted cells or we can match both the value like name and Skills from the sheet 2 and return the value in ECU HW Main Sheet "cell d9"

Regards,
Kunal Kumar

Originally Posted by dilipandey

Hi Kunal,

On what basis you want to change the Col_Index_Num i.e., is there any month / day you want to match and wish to include the matching number as Col_Index_Num so that you do not need to increase / change the same when you drag the formula. If possible, share the sample file. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

You can change the formula in D9 to this:

=VLOOKUP(D$3,Sheet2!$A$2:$H$25,MATCH($B9,Sheet2!$C$1:$H$1,0)+2,FALSE)

and then you can copy this down to D13.

Then you can copy the block D9:D13 across to F9, H9 etc, as in the attached file.

Hope this helps.

Pete