Index match formula working for some lines, but not others?

Index Match Function Excel: Full Tutorial and Examples index match INDEX MATCH simplifies finding the data you need, especially if you have multiple sheets that you need to pull the data from in Excel or Google Sheets index match MATCH returns a number value representing a cell in a row or column with an exact match of the search query, and the INDEX function returns the string present

full match The INDEX function used with the MATCH function allows for value searching in an array For example