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 have another list with these same names but in a different order, and not every name shows the suffix on that sheet. I cannot change the look of the names because the data on each sheet is taken from the internet. I want to match a name from sheet 2 that has a number associated with that name to the same name on sheet 1 and put the number beside the name. Unfortunately this does not always work because the sheets dont always show the correct last name.
How can I search to not be 100% exact, but rather search for a cell that includes the same names?
Thank you
Additional information
Index Match where Match numbers are not exact
=INDEX(B:B,MATCH(MIN(ABS(B:B-Ref)),ABS(B:B-Ref),0))
or
=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?
