INDEX MATCH VBA | INDEX MATCH FUNCTION | HOW TO USE INDEX MATCH IN VBA | INDEX MATCH MACRO |

[@JoseVazquez-l3h]

Excelente, me ayudo muchos saludos

[@shubhamtyagi3541]

Superb Sir. Now, I got how to use Index Match using Macros

[@kapilgurung5164]

INDEX Match.. best tutorial for me!!

[@delhitriggered962]

Its accurate and powerful. I tried myself. So Nice.

[@anglesingh6091]

U r great in computer 👍👍👍

[@HippieMosquitoQuatro]

You saved my life man, thank youu 🙏🙏

[@NaveenTamtaIamExcelVBA]

Thank you too

[@shabadgoonj9030]

Explained very well. Thank you!

[@transworld7913]

I learned a new thing. You have stored all values in respective variables. Very interesting!!

[@gftvgaandfaadtv4902]

Thank you very much Naveen. I have been searching for this code for weeks!

[@joebirmingham2843]

Very very good tutorial

[@ajinkyasundar7369]

A massive round of applause for this work!! Thanks!

[@tanyakohli8577]

Very important topic covered. Thank you!!

[@adityatalwar3733]

Very explanatory. Thanks for this video sir!

[@poonamshah4523]

Very Helpful Content

[@VeereDiWedding-tc6vt]

Paiji nu satshriakal...

[@techsavvyvlog1202]

This video worth liking

[@harmansinghsandhu9826]

Big thanks for going thru this and explaining it very clearly - this worked awesomely well :)

[@amansidhu1099]

Bhai WELL EXPLAINED

[@esrAsnataS]

Excellent, thank you very much!!

[@NaveenTamtaIamExcelVBA]

Thanx to you!!

[@techovega5179]

Agreeing with @Ajinkya Sunder

[@bnbn2822]

Nice tutorial

[@balrogbalrog1603]

Very informative. Very Nice!

[@radhikajoshi8440]

Very Helpful Naveen. Keep it up!

[@internetsmmgirl3019]

Its awesome

[@komitehoshikori1841]

Super Helpful!!

[@wifivlog2658]

Very informative and nice!

[@choppinguncle5542]

Amazing

[@fitnessgeek3350]

Fantastic. Keep Going

[@poojaa4010]

Liked It!

[@jeraldinejones9112]

Great one as usual.

[@kakabua7415]

Good Video!

[@technb2125]

Liked it!

[@tomokoshakazaki7925]

Lovely

[@SuperCupofcoffee]

What if your "VBA Output" Sheet was already populated and your "Data" Sheet only had 1 ID. And you wanted to run a VBA that would update only that ID on the "VBA Output" sheet without messing up the already populated fields in "VBA output". Say you wanted to change 10012's name on the "VBA Output" sheet by entering it on the "Data" sheet. How would that VBA look?

[@NaveenTamtaIamExcelVBA]

Let me have a look

[@kiddferr3448]

Hi can you help about index match. Its not taking the cell value but injecting a value on a table base on a criteria.

[@dennisbrinkley8613]

I want to create a VBS function that will do index match with no duplication. I have an array B8:C38 that I want to match with G7:P7 header row. The function will have subroutines named after the days of the week starting with Saturday. I will activate the subroutine with a macro button. I have an If index match small formula that works. I believe the VBS function would work better and be more secure from user mistakes. How can this be done?

[@NaveenTamtaIamExcelVBA]

Thanks Dennis for raising your concern.. can you please share a sample over my email I’d

[@dennisbrinkley8613]

@@NaveenTamtaIamExcelVBA Thank you very much for your response. I can email you example. Do you think a better approach would be to create a search array B8:C38, a filter criteria range G7:P7, and copy without duplicates to the output G8:P21? I would need a loop and message box Index Assigments Completed.

[@dennisbrinkley8613]

@@NaveenTamtaIamExcelVBA I can’t locate your email address.

[@NaveenTamtaIamExcelVBA]

[e-mail]

[@SB_Himalayan]

Great Solution, Hi Naveen I want to know one thing i am using the Index and Match function then why excel sheet start working slow in calculation. Please revert if you have any solution on this.

[@NaveenTamtaIamExcelVBA]

Dear friend use : Application.screenupdating=false Application.enableevents=false Application.displayalerts = false Just after you declared all your variables in order to run your vb script Faster. But don’t forget to change them as true just before end sub i.e. Application.screenupdating=true Application.enableevents=true Application.displayalerts=true End Sub

[@SB_Himalayan]

@@NaveenTamtaIamExcelVBA .Thanks for your response but I am using this as a formula in the cell instead of VBA and when I do an entry my excel goes hanged and went to the calculation mode which took lots of time and I took particular cell entries not entrie data. Please advise how would I do it.

[@tlee7028]

Thanks for sharing. I am a newbie in VBA. However, when I added an Inserted Row on the top 1:1 and also inserted extra column A, this index match does not work. Can you share what do I need to adjust in order to make the codes work? Thanks!

[@NaveenTamtaIamExcelVBA]

Hi lee, since, match function returns the position of a cell, so in your case, when you are inserting a new row all headers are getting shifted downwards and match formula is unable to find it.. that’s the reason your index match function is not working...

[@HerMagicWord323]

Hello sir same value is reflecting in the column can you help out for this

[@NaveenTamtaIamExcelVBA]

Share your code, so that I could see where exactly the problem is!!!

[@HerMagicWord323]

@@NaveenTamtaIamExcelVBA yes

[@HerMagicWord323]

Sir can you share your gmail id so that I can give you a code

[@tonyriti3699]

If I wanted to insert an additional condition ie another match statement how could I do it, thank you very much

[@NaveenTamtaIamExcelVBA]

Hi tony, I have been using Index match since a long time where one match is used to get records vertically and second match is based on headers horizontally. I never required to use 3rd match as two matches are pretty enough to get the required info. Please elaborate your query so that I could co-relate to this!!

[@tonyriti3699]

Thanks, I would need to process data with one condition per column and two conditions per row, in your example the vertical row is composed of ID Location Montly Salary Name Designation I would need further information in addition in row horizontal to these variables, for example educational qualification, let's imagine three variables relating to the degree, post degree, no degree.May thanks

[@coachwithsam3317]

Its tough!!

[@siddharthgurav6407]

Error 1004. wsVo select method failed

[@NaveenTamtaIamExcelVBA]

Check sheet name

[@Maverick-zp1dm]

Stop the background music