Forum Discussion
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 I'm unable to make it work. Can anyone please help me understand where I'm going wrong?
Thank you.
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.
3 Replies
- I solved it, thank you.
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.
