Issue with INDEX MATCH
Hello Everyone,
I have an index match formula that only works for the first row in my sheet and I have no idea why. The first row brings in the right value, all the other rows come back with #NO MATCH.
There is data to be pulled back for the other rows and a VLOOKUP works. What am I missing?
Thanks!!
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Best Answer
-
Try using a zero for the third portion of the MATCH function to specify an exact match.
Answers
-
Try using a zero for the third portion of the MATCH function to specify an exact match.
-
@Paul Newcome That fixed it! Thanks!
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!