Unsure why it's happening, but it works for all of the other values.
I have one table that has the following data I'm pulling as an index:
Case Name | Flagged for Review
7C-UCA | Yes
7C-UCB | Yes
7C-DAA | Yes
Cases are listed in $A$2:$A$9
Flagged for Review in $S$4:$S$9
2nd Table has a list of Equipment tied to that Specific Case
7C-UCA has 2
7C-DAA has 6
7C-UCB has 1
I wanted to flag each line of the 2nd table if the 1st table says that case is flagged
=INDEX($S$4:$S$10, MATCH(E14, $A$4:$A$10))
Where E14 is the case number on that row.
It works for 7C-UCA and 7C-UCB, but for some reason 7C-DAA results in a #N/A in the match function
Any thoughts?
Thank You!
Bookmarks