Getting error while indexing entries from other sheet.
Hello there!
A little background:
So I have 2 sheets that get inputs from two forms (Form 1 and Form 2). Both sheets belong to the same student(one gets filled by the college and one by the student). I am using the ID number as the identifier and
On the backend of Form 2 I have used the index match formula to gather all the information from Form 1 using the ID number as an identifier.
The formula is working correctly, when I make an entry on both forms, form 2 pulls all the information from form 1 (indexed) and 2 itself.
The problem arises when I make more than one entry, all the indexed values from the first entry start showing #NOMATCH, and when I make the third entry the first two show #NO MATCH, and so on.
Can anyone let me know what am I doing wrong here?
Attaching SS for reference
Answers
-
What exactly are your formulas, and are you able to provide a screenshot of the source(s)?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!