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