Forum Discussion
Solved
MATCHINDEX not displaying the correct value
https://docs.google.com/spreadsheets/d/1EmPXOKtjJWk5mXu6ZyCv7QvyM8g87dY1/edit?usp=sharing&ouid=105512111847352336211&rtpof=true&sd=true I've been trying to work MATCHINDEX between two sheets but...
You're trying to look up the gender on Sheet1. But the only other column with data on Sheet1 is Name, and the sheet with the formula (Index_Match_Practice) does not contain the name. So it's impossible.
If the Index_Match_Practice sheet had a Name column, it would work.
In your formula
=INDEX(
Sheet1!$E$4:$F$14,
MATCH(Sheet1!$E5, Sheet1!$E$4:$E$14, 0),
MATCH(Sheet1!$F5, Sheet1!$F$4:$F$14, 0)
)you try to return element from the array with two columns. If second MATCH() returns number more than 3 you have an error.
Didn't catch what you'd like to do with that formula, thus can't suggest how to change.