Need help of Index_Match and Vlookup_Match

[MRUGESH261987]

Hieeee.....Can any help me out to solve this problem using Index-Match and Vlook up-Match.

Problem Desc:

I want to move marks of each subject from Table_1 to Table_2 for each semester.

Thanks in Advance !!!

[twiggywales]

Demo_Marks.xlsx

here you go. hope that helps

Please Login or Register  to view this content.

drag and drop to suit

[MRUGESH261987]

Thank you so much twiggywales.

Can you pls help me to do the same using Vlookup_match and indirect function as well.

[twiggywales]

i can and will but why?

[MRUGESH261987]

Just wanna know..which one execute fast and easy to use..!!

Reason why I have large no. of database so excel take too much time to execute the same.

[twiggywales]

here you go

Demo_Marks (1).xlsx

hope that helps

just to let you know index/match is probably the best.

indirect is a no no as its a volatile function it can really slow things down.

[MRUGESH261987]

Once again Thank you...

This also help me to understand about all the function the way it works.

[twiggywales]

Glad i could help, if you are satisfied with the answer please mark the thread solved