Index Match Formula Help!

[gymwrecker]

Working with Index Match for the first time; keeps returning an error #N/A.

=INDEX(DATA!A2:G102,MATCH(DATA!A2:A102,0),COLUMN(DATA!A1))

I'm using MS Excel for Mac 2016. Is there a way to attach the file to this thread?

 

[AhoyNC]

Maybe these links will help.
One thing I noticed is in your MATCH function you left out the value you want to match.

https://support.office.com/en-us/ar...pId=xlmain11.chm60112&ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/ar...pId=xlmain11.chm60077&ui=en-US&rs=en-US&ad=US

From Excel is Fun:
https://www.youtube.com/watch?v=bMWv0AN-hSs

 

[gymwrecker]

AhoyNC, Thank you for your help, it's working now! I greatly appreciate it!!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.