Forum Discussion
Index Match not exact
I am currently using an Index match function to fill in data from one sheet to another. On sheet 1, I have a list of names that have a variety of different suffixes (jr. III, II, ect.). On sheet 2, I...
=INDEX($G$4:$G$18,MATCH(LEFT(B4,FIND(" ",B4)-1),$F$4:$F$18,0))Is this similar to what you are looking for?