INDEX MATCH to get whole Row/Column Excel Formula | index match vs vlookup | multiple results

preview_player
Показать описание
You can Book a Meeting For Consultation at:

The INDEX MATCH formula is an alternative to Vlookup Formula with Much More Features. By using the Index match Formula you can Lookup a Whole column or whole row and can get multiple results that could not be done by a Vlookup Formula. Index match excel is better than using VBA.
Complex Index match vs vlookup | index match vlookup ka baap
In Index match exact Function we can match the value by exactly matching the value and we also have an option for lower than and greater than value. I have used the index match excel multiple criteria Formula in this Video. We can also use index match excel multiple sheets. In that Function, We can select Multiple sheets to get results.
We can call this formula "Index match excel superstar".
I would Keep on explaining excel functions on my Youtube Channel.
I have explained the index match for multiple matches but if anyone needs any further explanation you can contact me.
If you have any index match errors just let me know in the comments section and I would help you right now.

You can visit our Website at :

Support My Channel on Patreon:
Рекомендации по теме
Комментарии
Автор

I was looking for this video from last several months on Google...
Finally i found it...
Thanks🙏🙏🙏

Awesome

ashiqmir
Автор

Great work mate. So many other channels do obscure ideas. This is an obvious and highly useful task in excel.

Stevo
Автор

hi,
i am also trying this, but only got single value, even i am only using your sheet which your provided i video description. i send you my sheet in your mail id. kindly help it.

harshdeepsingh
Автор

Hi. When I press enter, I get a single value. The whole row is not coming out. Please help

xhaolee
Автор

Hi, I'm facing a similar problem to Xhao Lee.

juliantan
Автор

How you retrieve whole single row, would like to know multiple rows how can retrieve like single row

AhsanUllah-ktsb
Автор

Hello! may I ask what if the data I'm looking for has a duplicate?

phlinx
Автор

Hi.Please Help When I press enter, I get a single value. The whole row is not coming out.

bilalsamarathunga