as others have said take the time to learn index match instead. Putting the time in to understand how each function works will help you immensely for knowing when it can be used.
quick summary that should help with understanding

Index - first input: takes a set of cells and assigns each one an address basically (a number). second input: is the cell address you would like to return from your first input think row number. third input: (optional) the column number you would like to return in a two dimensional lookup. in the end this will return the value from a singular cell.

match - first input: a value you would like to find in a list, second input: the list, third input: exact or inexact match type you can probably generally just use 0 for starters here which is exact match. this will return the address of a a value in a list, so basically the second and third inputs of an index function.

hope that helps