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

[@ashiqmir2717]

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

[@definitesys7604]

Happy to help!

[@xhaolee1920]

This is not working. It is only giving a single value. Can you help here?

[@definitesys7604]

​ Hi, @Xhao Lee Thanks for Connecting!
Can you send me the formula or the google sheet link you are working on so I can check?
I have contact links in the video Description if you Like to contact me.

[@Stevo1361]

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

[@AnilKariwala]

Great! Amazing clarity!!

[@PrakashKumar-gn1ji]

Thank you so much :)

[@abdalbastsalm5801]

wonderful

[@zainabbibi3689]

Great formula. Thanks!

[@definitesys7604]

You're welcome!

[@phlinx4164]

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

[@definitesys7604]

It would return the first matching row

[@definitesys7604]

It would return the first matching row

[@megaladonas]

Thank you for the help

[@definitesys7604]

Happy to help

[@harshdeepsingh1582]

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.

[@definitesys7604]

Hi I have sent the reply Email with the Corrected Formula

[@xhaolee1920]

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

[@definitesys7604]

​ Hi, @Xhao Lee Thanks for Connecting!
Can you send me the formula or the google sheet link you are working on so I can check?
I have contact links in the video Description if you Like to contact me.

[@AhsanUllah-kt1sb]

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

[@definitesys7604]

Thanks for connecting!
We can use Filter function to retrieve multiple rows based on a criteria.

[@definitesys7604]

ruclips.net/video/772xUcjiw10/видео.html

[@juliantan1168]

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

[@definitesys7604]

Hi, @Julian Tan Thanks for Connecting!
Can you send me the formula or the google sheet link you are working on so I can check?
I have contact links in the video Description if you Like to contact me.

[@definitesys7604]

You can contact me at [e-mail]

[@bilalsamarathunga5686]

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

[@definitesys7604]

Are you using it on excel or google sheets ?

[@atulverma_]

thanks a lot

[@definitesys7604]

You are most welcome

[@haris-khan623]

Why is it giving me error #value

[@definitesys7604]

Send us the formula.
Make sure you are using Google Sheets