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.
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.