The array formula in this blog article has no "Fuzzy logic" nor vlookup function. But it can return names or words arranged differently and with minor misspellings just like a user defined function with "Fuzzy logic".

There are too many nested functions in this array formula so it works only in excel 2007 and later versions. It searches for values in List 2 and returns matching values in column C,D and E. I have bolded the correct answer in column C, D or E. As you can see, the first returning value (col C) isn´t always the right answer.

### Array formula in cell C2:

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "") + CTRL + SHIFT + ENTER

Copy cell C2 and paste to C2:E100.

### Named range

List2 (Sheet1!G2:G100)

### Explaining array formula in cell C2

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

Step 1 - Split characters in cell B2 into an array

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1)

becomes

MID("Edward Hall", ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN("Edward Hall"))), 1)

becomes

MID("Edward Hall", ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, 11)), 1)

becomes

MID("Edward Hall", ROW(\$A\$1:\$A\$11), 1)

becomes

MID("Edward Hall", {1;2;3;4;5;6;7;8;9;10;11}, 1)

and returns this array {"E";"d";"w";"a";"r";"d";" ";"H";"a";"l";"l"}

Step 2 - Search for characters in List 2

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

SEARCH(MID(\$B2;ROW(\$A\$1:INDEX(\$A\$1:\$A\$100;LEN(\$B2)));1);TRANSPOSE(List2))

becomes

SEARCH({"E";"d";"w";"a";"r";"d";" ";"H";"a";"l";"l"};TRANSPOSE(List2))

becomes

SEARCH({"E";"d";"w";"a";"r";"d";" ";"H";"a";"l";"l"};TRANSPOSE({"Lewis E. Charles ", "Young P. Nancy ", "Evans A. Thomas ", "Robinson C. George ", "Moore W. Thomas ", "Phillips M. Thomas ", "Moore T. Michelle ", "White X. Sandra ", "Evans O. Linda ", "Perez Y. Michael ", "Martinez U. David ", "Roberts H. Patricia ", "Taylor D. Anthony ", "Lee P. Thomas ", "Scott X. Paul ", "Moore O. William ", "Wright Z. Steven ", "Edwards P. John ", "Jones N. John ", "Johnson U. Paul ", "Edwards I. Sarah ", "Thompson J. Mary ", "Johnson Q. Richard ", "White W. Robert ", "Scott A. George ", "Baker E. Susan ", "Martin U. Jeff ", "Hall W. Jeff ", "Campbell B. Jennifer ", "Harris H. Sandra ", "Jackson R. Jeff ", "Collins D. George ", "Rodriguez F. Ronald ", "Rodriguez Q. James ", "Robinson X. Patricia ", "Parker P. Sarah ", "Evans N. Donald ", "Davis D. David ", "Scott C. Michael ", "Garcia O. Mark ", "Johnson V. James ", "Anderson F. Mary ", "Phillips V. Deborah ", "Davis V. Paul ", "Martinez G. Donald ", "Phillips C. Sharon ", "Robinson C. Sandra ", "Parker E. Richard ", "Green G. Sarah ", "Williams A. Sandra ", "Taylor B. Thomas ", "Parker D. Richard ", "Gonzalez Q. Laura ", "Martin Q. Kenneth ", "Martinez F. Elizabeth ", "Hernandez I. Richard ", "Allen Z. William ", "Thompson A. Jason ", "Baker S. Helen ", "Phillips O. Jennifer ", "Rodriguez N. Deborah ", "Miller U. Michelle ", "Moore I. Thomas ", "Rodriguez Z. Robert ", "Hall N. Edward ", "Lewis S. Robert ", "Phillips I. Ruth ", "Young R. Kevin ", "Harris U. Jason ", "Parker H. Steven ", "Nelson Y. Kevin ", "Wilson N. Anthony ", "Gonzalez T. Paul ", "Hernandez H. Sandra ", "Martin P. Helen ", "White X. Sandra ", "Moore T. Helen ", "Adams Y. Edward ", "Thompson B. Elizabeth ", "Thomas K. Margaret ", "Collins S. Susan ", "Campbell M. Ronald ", "Taylor B. Mary ", "Taylor G. Deborah ", "Moore A. James ", "Collins O. Anthony ", "Phillips L. Linda ", "Wright G. Daniel ", "Thomas N. Patricia ", "Jackson S. Charles ", "Thompson I. Richard ", "Campbell R. Kimberly ", "Brown J. James ", "Lee Y. David ", "Hill F. Richard ", "Wright E. Linda ", "Taylor I. Helen ", "Walker S. Kevin ", "Lee I. Sharon "}))

and returns

{2, #VALUE!, 1, 14, 5, #VALUE!, 5, 5, 1, 2, 7, 4, #VALUE!, 2, #VALUE!, 5, 13, 1, 4, #VALUE!, 1, #VALUE!, #VALUE!, 5, 11, 4, 12, 10, 6, #VALUE!, 13, 13, 8, 8, #VALUE!, 5, 1, #VALUE!, 15, #VALUE!, 15, 4, 14, #VALUE!, 7, #VALUE!, #VALUE!, 5, 3, #VALUE!, #VALUE!, 5, 7, 12, 7, 2, 4, #VALUE!, 4, 14, 8, 5, 5, 8, 9, 2, #VALUE!, 11, #VALUE!, 5, 2, #VALUE!, 7, 2, 12, 5, 5, 10, 13, 17, #VALUE!, 6, #VALUE!, 12, 5, #VALUE!, #VALUE!, 15, #VALUE!, 17, #VALUE!, 6, 13, 2, #VALUE!, 8, 12, 5, 2;#VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 13, 13, #VALUE!, 13, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 18, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 9, 3, 3, #VALUE!, #VALUE!, 10, 1, #VALUE!, #VALUE!, #VALUE!, 3, 13, 1, 13, #VALUE!, 16, 17, #VALUE!, 16, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 3, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, 13, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 18, #VALUE!, 11, #VALUE!, #VALUE!, 16, 11, #VALUE!, #VALUE!, 19, #VALUE!, #VALUE!, 8, 15, 14, #VALUE!, #VALUE!, #VALUE!;3, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 10, 1, 3, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, 6, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 11, 3, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, 12, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, #VALUE!, #VALUE!, 1, #VALUE!, 1, #VALUE!;12, 11, 3, #VALUE!, 14, 17, #VALUE!, 11, 3, 14, 2, 13, 2, 12, 11, 15, #VALUE!, 4, #VALUE!, 13, 4, 14, 16, #VALUE!, 7, 2, 2, 2, 2, 2, 2, #VALUE!, 17, 15, 14, 2, 3, 2, 14, 2, 13, 1, 18, 2, 2, 15, 14, 2, 11, 6, 2, 2, 5, 2, 2, 5, 1, 10, 2, #VALUE!, 19, #VALUE!, 14, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 2, 2, #VALUE!, 11, 5, 5, 2, 11, #VALUE!, 1, 17, 5, 15, 2, 2, 2, 7, 12, 17, 12, 5, 2, 17, 2, 11, 9, 13, 15, 2, 2, 10;13, #VALUE!, #VALUE!, 1, 4, #VALUE!, 4, 14, #VALUE!, 3, 3, 1, 6, #VALUE!, #VALUE!, 4, 2, 5, #VALUE!, #VALUE!, 5, 15, 12, 10, 13, 5, 3, #VALUE!, 20, 3, 9, 15, 1, 1, 1, 3, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, 5, 17, #VALUE!, 3, 16, 1, 3, 2, 17, 6, 3, 16, 3, 3, 3, #VALUE!, #VALUE!, 5, 20, 1, 6, 4, 1, 13, 10, 13, 7, 3, 3, #VALUE!, #VALUE!, #VALUE!, 3, 3, 14, 4, 14, #VALUE!, 13, #VALUE!, 13, 6, 6, 4, #VALUE!, #VALUE!, 2, 14, 15, 13, 10, 2, #VALUE!, 9, 2, 6, 6, 11;#VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 13, 13, #VALUE!, 13, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 18, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 9, 3, 3, #VALUE!, #VALUE!, 10, 1, #VALUE!, #VALUE!, #VALUE!, 3, 13, 1, 13, #VALUE!, 16, 17, #VALUE!, 16, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 3, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, 13, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 18, #VALUE!, 11, #VALUE!, #VALUE!, 16, 11, #VALUE!, #VALUE!, 19, #VALUE!, #VALUE!, 8, 15, 14, #VALUE!, #VALUE!, #VALUE!;6, 6, 6, 9, 6, 9, 6, 6, 6, 6, 9, 8, 7, 4, 6, 6, 7, 8, 6, 8, 8, 9, 8, 6, 6, 6, 7, 5, 9, 7, 8, 8, 10, 10, 9, 7, 6, 6, 6, 7, 8, 9, 9, 6, 9, 9, 9, 7, 6, 9, 7, 7, 9, 7, 9, 10, 6, 9, 6, 9, 10, 7, 6, 10, 5, 6, 9, 6, 7, 7, 7, 7, 9, 10, 7, 6, 6, 6, 9, 7, 8, 9, 7, 7, 6, 8, 9, 7, 7, 8, 9, 9, 6, 4, 5, 7, 7, 7, 4;11, #VALUE!, 11, #VALUE!, 11, 2, 13, 2, #VALUE!, 13, #VALUE!, 9, 14, 9, #VALUE!, #VALUE!, 5, 14, 12, 3, 16, 2, 3, 2, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, 13, #VALUE!, 3, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 14, 14, #VALUE!, 12, 14, #VALUE!, 17, 21, 1, #VALUE!, 2, 10, 2, 20, 14, 11, #VALUE!, 1, #VALUE!, 2, #VALUE!, 1, 8, #VALUE!, 14, #VALUE!, 1, 11, 2, 10, #VALUE!, 2, 2, #VALUE!, #VALUE!, #VALUE!, 17, #VALUE!, 15, 2, 5, 2, 13, 2, #VALUE!, #VALUE!, #VALUE!, 1, 5, 11, #VALUE!, 9;12, 11, 3, #VALUE!, 14, 17, #VALUE!, 11, 3, 14, 2, 13, 2, 12, 11, 15, #VALUE!, 4, #VALUE!, 13, 4, 14, 16, #VALUE!, 7, 2, 2, 2, 2, 2, 2, #VALUE!, 17, 15, 14, 2, 3, 2, 14, 2, 13, 1, 18, 2, 2, 15, 14, 2, 11, 6, 2, 2, 5, 2, 2, 5, 1, 10, 2, #VALUE!, 19, #VALUE!, 14, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 2, 2, #VALUE!, 11, 5, 5, 2, 11, #VALUE!, 1, 17, 5, 15, 2, 2, 2, 7, 12, 17, 12, 5, 2, 17, 2, 11, 9, 13, 15, 2, 2, 10;1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, 15, #VALUE!, 10, 16, #VALUE!, #VALUE!, 4, 1, 13, 12, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, 7, #VALUE!, #VALUE!, 3, 18, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 16, #VALUE!, #VALUE!, #VALUE!, 4, 13, 17, 4, #VALUE!, #VALUE!, #VALUE!, 3, 4, #VALUE!, 6, #VALUE!, 14, #VALUE!, 2, #VALUE!, 12, 4, #VALUE!, 3, #VALUE!, #VALUE!, 3, 1, 4, #VALUE!, #VALUE!, #VALUE!, 3, 3, 6, #VALUE!, 13, #VALUE!, 12, #VALUE!, 14, #VALUE!, 3, 7, 4, 4, #VALUE!, 3, 4, 16, #VALUE!, 16, #VALUE!, 7, #VALUE!, 1, 3, 11, 4, 3, 1;1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, 15, #VALUE!, 10, 16, #VALUE!, #VALUE!, 4, 1, 13, 12, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, 7, #VALUE!, #VALUE!, 3, 18, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 16, #VALUE!, #VALUE!, #VALUE!, 4, 13, 17, 4, #VALUE!, #VALUE!, #VALUE!, 3, 4, #VALUE!, 6, #VALUE!, 14, #VALUE!, 2, #VALUE!, 12, 4, #VALUE!, 3, #VALUE!, #VALUE!, 3, 1, 4, #VALUE!, #VALUE!, #VALUE!, 3, 3, 6, #VALUE!, 13, #VALUE!, 12, #VALUE!, 14, #VALUE!, 3, 7, 4, 4, #VALUE!, 3, 4, 16, #VALUE!, 16, #VALUE!, 7, #VALUE!, 1, 3, 11, 4, 3, 1}

Step 3 - Convert values into row numbers

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1))

becomes

IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99})

becomes

IF(ISERROR({2, #VALUE!, 1, 14, 5, #VALUE!, 5, 5, 1, 2, 7, 4, #VALUE!, 2, #VALUE!, 5, 13, 1, 4, #VALUE!, 1, #VALUE!, #VALUE!, 5, 11, 4, 12, 10, 6, #VALUE!, 13, 13, 8, 8, #VALUE!, 5, 1, #VALUE!, 15, #VALUE!, 15, 4, 14, #VALUE!, 7, #VALUE!, #VALUE!, 5, 3, #VALUE!, #VALUE!, 5, 7, 12, 7, 2, 4, #VALUE!, 4, 14, 8, 5, 5, 8, 9, 2, #VALUE!, 11, #VALUE!, 5, 2, #VALUE!, 7, 2, 12, 5, 5, 10, 13, 17, #VALUE!, 6, #VALUE!, 12, 5, #VALUE!, #VALUE!, 15, #VALUE!, 17, #VALUE!, 6, 13, 2, #VALUE!, 8, 12, 5, 2;#VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 13, 13, #VALUE!, 13, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 18, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 9, 3, 3, #VALUE!, #VALUE!, 10, 1, #VALUE!, #VALUE!, #VALUE!, 3, 13, 1, 13, #VALUE!, 16, 17, #VALUE!, 16, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 3, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, 13, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 18, #VALUE!, 11, #VALUE!, #VALUE!, 16, 11, #VALUE!, #VALUE!, 19, #VALUE!, #VALUE!, 8, 15, 14, #VALUE!, #VALUE!, #VALUE!;3, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 10, 1, 3, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, 6, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 11, 3, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, 12, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, #VALUE!, #VALUE!, 1, #VALUE!, 1, #VALUE!;12, 11, 3, #VALUE!, 14, 17, #VALUE!, 11, 3, 14, 2, 13, 2, 12, 11, 15, #VALUE!, 4, #VALUE!, 13, 4, 14, 16, #VALUE!, 7, 2, 2, 2, 2, 2, 2, #VALUE!, 17, 15, 14, 2, 3, 2, 14, 2, 13, 1, 18, 2, 2, 15, 14, 2, 11, 6, 2, 2, 5, 2, 2, 5, 1, 10, 2, #VALUE!, 19, #VALUE!, 14, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 2, 2, #VALUE!, 11, 5, 5, 2, 11, #VALUE!, 1, 17, 5, 15, 2, 2, 2, 7, 12, 17, 12, 5, 2, 17, 2, 11, 9, 13, 15, 2, 2, 10;13, #VALUE!, #VALUE!, 1, 4, #VALUE!, 4, 14, #VALUE!, 3, 3, 1, 6, #VALUE!, #VALUE!, 4, 2, 5, #VALUE!, #VALUE!, 5, 15, 12, 10, 13, 5, 3, #VALUE!, 20, 3, 9, 15, 1, 1, 1, 3, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, 5, 17, #VALUE!, 3, 16, 1, 3, 2, 17, 6, 3, 16, 3, 3, 3, #VALUE!, #VALUE!, 5, 20, 1, 6, 4, 1, 13, 10, 13, 7, 3, 3, #VALUE!, #VALUE!, #VALUE!, 3, 3, 14, 4, 14, #VALUE!, 13, #VALUE!, 13, 6, 6, 4, #VALUE!, #VALUE!, 2, 14, 15, 13, 10, 2, #VALUE!, 9, 2, 6, 6, 11;#VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 13, 13, #VALUE!, 13, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 18, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 9, 3, 3, #VALUE!, #VALUE!, 10, 1, #VALUE!, #VALUE!, #VALUE!, 3, 13, 1, 13, #VALUE!, 16, 17, #VALUE!, 16, #VALUE!, 8, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, #VALUE!, #VALUE!, 3, 10, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 7, #VALUE!, 13, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 18, #VALUE!, 11, #VALUE!, #VALUE!, 16, 11, #VALUE!, #VALUE!, 19, #VALUE!, #VALUE!, 8, 15, 14, #VALUE!, #VALUE!, #VALUE!;6, 6, 6, 9, 6, 9, 6, 6, 6, 6, 9, 8, 7, 4, 6, 6, 7, 8, 6, 8, 8, 9, 8, 6, 6, 6, 7, 5, 9, 7, 8, 8, 10, 10, 9, 7, 6, 6, 6, 7, 8, 9, 9, 6, 9, 9, 9, 7, 6, 9, 7, 7, 9, 7, 9, 10, 6, 9, 6, 9, 10, 7, 6, 10, 5, 6, 9, 6, 7, 7, 7, 7, 9, 10, 7, 6, 6, 6, 9, 7, 8, 9, 7, 7, 6, 8, 9, 7, 7, 8, 9, 9, 6, 4, 5, 7, 7, 7, 4;11, #VALUE!, 11, #VALUE!, 11, 2, 13, 2, #VALUE!, 13, #VALUE!, 9, 14, 9, #VALUE!, #VALUE!, 5, 14, 12, 3, 16, 2, 3, 2, #VALUE!, #VALUE!, #VALUE!, 1, #VALUE!, 1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, 13, #VALUE!, 3, #VALUE!, 2, #VALUE!, #VALUE!, 2, #VALUE!, 14, 14, #VALUE!, 12, 14, #VALUE!, 17, 21, 1, #VALUE!, 2, 10, 2, 20, 14, 11, #VALUE!, 1, #VALUE!, 2, #VALUE!, 1, 8, #VALUE!, 14, #VALUE!, 1, 11, 2, 10, #VALUE!, 2, 2, #VALUE!, #VALUE!, #VALUE!, 17, #VALUE!, 15, 2, 5, 2, 13, 2, #VALUE!, #VALUE!, #VALUE!, 1, 5, 11, #VALUE!, 9;12, 11, 3, #VALUE!, 14, 17, #VALUE!, 11, 3, 14, 2, 13, 2, 12, 11, 15, #VALUE!, 4, #VALUE!, 13, 4, 14, 16, #VALUE!, 7, 2, 2, 2, 2, 2, 2, #VALUE!, 17, 15, 14, 2, 3, 2, 14, 2, 13, 1, 18, 2, 2, 15, 14, 2, 11, 6, 2, 2, 5, 2, 2, 5, 1, 10, 2, #VALUE!, 19, #VALUE!, 14, #VALUE!, 2, #VALUE!, #VALUE!, #VALUE!, 2, 2, #VALUE!, 11, 5, 5, 2, 11, #VALUE!, 1, 17, 5, 15, 2, 2, 2, 7, 12, 17, 12, 5, 2, 17, 2, 11, 9, 13, 15, 2, 2, 10;1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, 15, #VALUE!, 10, 16, #VALUE!, #VALUE!, 4, 1, 13, 12, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, 7, #VALUE!, #VALUE!, 3, 18, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 16, #VALUE!, #VALUE!, #VALUE!, 4, 13, 17, 4, #VALUE!, #VALUE!, #VALUE!, 3, 4, #VALUE!, 6, #VALUE!, 14, #VALUE!, 2, #VALUE!, 12, 4, #VALUE!, 3, #VALUE!, #VALUE!, 3, 1, 4, #VALUE!, #VALUE!, #VALUE!, 3, 3, 6, #VALUE!, 13, #VALUE!, 12, #VALUE!, 14, #VALUE!, 3, 7, 4, 4, #VALUE!, 3, 4, 16, #VALUE!, 16, #VALUE!, 7, #VALUE!, 1, 3, 11, 4, 3, 1;1, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 4, 15, #VALUE!, 10, 16, #VALUE!, #VALUE!, 4, 1, 13, 12, #VALUE!, #VALUE!, #VALUE!, 15, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, #VALUE!, 3, 7, #VALUE!, #VALUE!, 3, 18, #VALUE!, #VALUE!, #VALUE!, 14, #VALUE!, 16, #VALUE!, #VALUE!, #VALUE!, 4, 13, 17, 4, #VALUE!, #VALUE!, #VALUE!, 3, 4, #VALUE!, 6, #VALUE!, 14, #VALUE!, 2, #VALUE!, 12, 4, #VALUE!, 3, #VALUE!, #VALUE!, 3, 1, 4, #VALUE!, #VALUE!, #VALUE!, 3, 3, 6, #VALUE!, 13, #VALUE!, 12, #VALUE!, 14, #VALUE!, 3, 7, 4, 4, #VALUE!, 3, 4, 16, #VALUE!, 16, #VALUE!, 7, #VALUE!, 1, 3, 11, 4, 3, 1}, TRANSPOSE(List2))), "", {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99})

becomes

IF({FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE;TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE;FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE;FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE;FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE;TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE;FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE;FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE;FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE;FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE;FALSE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, TRUE, FALSE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, TRUE, FALSE, TRUE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE}, "", {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99})

and returns

{1, "", 3, 4, 5, "", 7, 8, 9, 10, 11, 12, "", 14, "", 16, 17, 18, 19, "", 21, "", "", 24, 25, 26, 27, 28, 29, "", 31, 32, 33, 34, "", 36, 37, "", 39, "", 41, 42, 43, "", 45, "", "", 48, 49, "", "", 52, 53, 54, 55, 56, 57, "", 59, 60, 61, 62, 63, 64, 65, 66, "", 68, "", 70, 71, "", 73, 74, 75, 76, 77, 78, 79, 80, "", 82, "", 84, 85, "", "", 88, "", 90, "", 92, 93, 94, "", 96, 97, 98, 99;"", "", "", "", "", "", "", 8, 9, "", 11, "", 13, "", "", "", "", 18, "", "", 21, "", 23, "", "", "", "", "", "", 30, "", 32, 33, 34, "", "", 37, 38, "", "", "", 42, 43, 44, 45, "", 47, 48, "", 50, "", 52, "", "", "", 56, "", "", "", "", 61, "", "", 64, 65, "", "", "", "", "", "", "", "", 74, "", 76, "", 78, "", "", "", 82, "", 84, "", "", 87, 88, "", "", 91, "", "", 94, 95, 96, "", "", "";1, "", "", "", 5, "", "", 8, "", "", "", "", "", "", "", 16, 17, 18, "", "", 21, "", "", 24, "", "", "", 28, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", 50, "", "", "", "", "", "", 57, "", "", "", "", "", "", "", 65, 66, "", "", "", "", "", 72, "", "", "", 76, "", 78, "", "", "", "", "", "", "", "", "", 88, "", "", "", "", 93, "", "", 96, "", 98, "";1, 2, 3, "", 5, 6, "", 8, 9, 10, 11, 12, 13, 14, 15, 16, "", 18, "", 20, 21, 22, 23, "", 25, 26, 27, 28, 29, 30, 31, "", 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, "", 61, "", 63, "", 65, "", "", "", 69, 70, "", 72, 73, 74, 75, 76, "", 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", "", 4, 5, "", 7, 8, "", 10, 11, 12, 13, "", "", 16, 17, 18, "", "", 21, 22, 23, 24, 25, 26, 27, "", 29, 30, 31, 32, 33, 34, 35, 36, "", "", "", 40, "", 42, 43, "", 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, "", "", 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, "", "", "", 74, 75, 76, 77, 78, "", 80, "", 82, 83, 84, 85, "", "", 88, 89, 90, 91, 92, 93, "", 95, 96, 97, 98, 99;"", "", "", "", "", "", "", 8, 9, "", 11, "", 13, "", "", "", "", 18, "", "", 21, "", 23, "", "", "", "", "", "", 30, "", 32, 33, 34, "", "", 37, 38, "", "", "", 42, 43, 44, 45, "", 47, 48, "", 50, "", 52, "", "", "", 56, "", "", "", "", 61, "", "", 64, 65, "", "", "", "", "", "", "", "", 74, "", 76, "", 78, "", "", "", 82, "", 84, "", "", 87, 88, "", "", 91, "", "", 94, 95, 96, "", "", "";1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", 3, "", 5, 6, 7, 8, "", 10, "", 12, 13, 14, "", "", 17, 18, 19, 20, 21, 22, 23, 24, "", "", "", 28, "", 30, "", "", "", "", "", 36, "", "", 39, "", 41, "", 43, "", "", 46, "", 48, 49, "", 51, 52, "", 54, 55, 56, "", 58, 59, 60, 61, 62, 63, "", 65, "", 67, "", 69, 70, "", 72, "", 74, 75, 76, 77, "", 79, 80, "", "", "", 84, "", 86, 87, 88, 89, 90, 91, "", "", "", 95, 96, 97, "", 99;1, 2, 3, "", 5, 6, "", 8, 9, 10, 11, 12, 13, 14, 15, 16, "", 18, "", 20, 21, 22, 23, "", 25, 26, 27, 28, 29, 30, 31, "", 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, "", 61, "", 63, "", 65, "", "", "", 69, 70, "", 72, 73, 74, 75, 76, "", 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", "", "", "", 6, 7, "", 9, 10, "", "", 13, 14, 15, 16, "", "", "", 20, "", "", "", "", "", "", "", 28, 29, "", "", 32, 33, "", "", "", 37, "", 39, "", "", "", 43, 44, 45, 46, "", "", "", 50, 51, "", 53, "", 55, "", 57, "", 59, 60, "", 62, "", "", 65, 66, 67, "", "", "", 71, 72, 73, "", 75, "", 77, "", 79, "", 81, 82, 83, 84, "", 86, 87, 88, "", 90, "", 92, "", 94, 95, 96, 97, 98, 99;1, "", "", "", "", 6, 7, "", 9, 10, "", "", 13, 14, 15, 16, "", "", "", 20, "", "", "", "", "", "", "", 28, 29, "", "", 32, 33, "", "", "", 37, "", 39, "", "", "", 43, 44, 45, 46, "", "", "", 50, 51, "", 53, "", 55, "", 57, "", 59, 60, "", 62, "", "", 65, 66, 67, "", "", "", 71, 72, 73, "", 75, "", 77, "", 79, "", 81, 82, 83, 84, "", 86, 87, 88, "", 90, "", 92, "", 94, 95, 96, 97, 98, 99}

Step 4 - Calculate row number frequency and return most frequent row number

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))

becomes

MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), {1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; 13; 14; 15; 16; 17; 18; 19; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 40; 41; 42; 43; 44; 45; 46; 47; 48; 49; 50; 51; 52; 53; 54; 55; 56; 57; 58; 59; 60; 61; 62; 63; 64; 65; 66; 67; 68; 69; 70; 71; 72; 73; 74; 75; 76; 77; 78; 79; 80; 81; 82; 83; 84; 85; 86; 87; 88; 89; 90; 91; 92; 93; 94; 95; 96; 97; 98; 99; 100}))

becomes

MAX(FREQUENCY({1, "", 3, 4, 5, "", 7, 8, 9, 10, 11, 12, "", 14, "", 16, 17, 18, 19, "", 21, "", "", 24, 25, 26, 27, 28, 29, "", 31, 32, 33, 34, "", 36, 37, "", 39, "", 41, 42, 43, "", 45, "", "", 48, 49, "", "", 52, 53, 54, 55, 56, 57, "", 59, 60, 61, 62, 63, 64, 65, 66, "", 68, "", 70, 71, "", 73, 74, 75, 76, 77, 78, 79, 80, "", 82, "", 84, 85, "", "", 88, "", 90, "", 92, 93, 94, "", 96, 97, 98, 99;"", "", "", "", "", "", "", 8, 9, "", 11, "", 13, "", "", "", "", 18, "", "", 21, "", 23, "", "", "", "", "", "", 30, "", 32, 33, 34, "", "", 37, 38, "", "", "", 42, 43, 44, 45, "", 47, 48, "", 50, "", 52, "", "", "", 56, "", "", "", "", 61, "", "", 64, 65, "", "", "", "", "", "", "", "", 74, "", 76, "", 78, "", "", "", 82, "", 84, "", "", 87, 88, "", "", 91, "", "", 94, 95, 96, "", "", "";1, "", "", "", 5, "", "", 8, "", "", "", "", "", "", "", 16, 17, 18, "", "", 21, "", "", 24, "", "", "", 28, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", 50, "", "", "", "", "", "", 57, "", "", "", "", "", "", "", 65, 66, "", "", "", "", "", 72, "", "", "", 76, "", 78, "", "", "", "", "", "", "", "", "", 88, "", "", "", "", 93, "", "", 96, "", 98, "";1, 2, 3, "", 5, 6, "", 8, 9, 10, 11, 12, 13, 14, 15, 16, "", 18, "", 20, 21, 22, 23, "", 25, 26, 27, 28, 29, 30, 31, "", 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, "", 61, "", 63, "", 65, "", "", "", 69, 70, "", 72, 73, 74, 75, 76, "", 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", "", 4, 5, "", 7, 8, "", 10, 11, 12, 13, "", "", 16, 17, 18, "", "", 21, 22, 23, 24, 25, 26, 27, "", 29, 30, 31, 32, 33, 34, 35, 36, "", "", "", 40, "", 42, 43, "", 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, "", "", 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, "", "", "", 74, 75, 76, 77, 78, "", 80, "", 82, 83, 84, 85, "", "", 88, 89, 90, 91, 92, 93, "", 95, 96, 97, 98, 99;"", "", "", "", "", "", "", 8, 9, "", 11, "", 13, "", "", "", "", 18, "", "", 21, "", 23, "", "", "", "", "", "", 30, "", 32, 33, 34, "", "", 37, 38, "", "", "", 42, 43, 44, 45, "", 47, 48, "", 50, "", 52, "", "", "", 56, "", "", "", "", 61, "", "", 64, 65, "", "", "", "", "", "", "", "", 74, "", 76, "", 78, "", "", "", 82, "", 84, "", "", 87, 88, "", "", 91, "", "", 94, 95, 96, "", "", "";1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", 3, "", 5, 6, 7, 8, "", 10, "", 12, 13, 14, "", "", 17, 18, 19, 20, 21, 22, 23, 24, "", "", "", 28, "", 30, "", "", "", "", "", 36, "", "", 39, "", 41, "", 43, "", "", 46, "", 48, 49, "", 51, 52, "", 54, 55, 56, "", 58, 59, 60, 61, 62, 63, "", 65, "", 67, "", 69, 70, "", 72, "", 74, 75, 76, 77, "", 79, 80, "", "", "", 84, "", 86, 87, 88, 89, 90, 91, "", "", "", 95, 96, 97, "", 99;1, 2, 3, "", 5, 6, "", 8, 9, 10, 11, 12, 13, 14, 15, 16, "", 18, "", 20, 21, 22, 23, "", 25, 26, 27, 28, 29, 30, 31, "", 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, "", 61, "", 63, "", 65, "", "", "", 69, 70, "", 72, 73, 74, 75, 76, "", 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99;1, "", "", "", "", 6, 7, "", 9, 10, "", "", 13, 14, 15, 16, "", "", "", 20, "", "", "", "", "", "", "", 28, 29, "", "", 32, 33, "", "", "", 37, "", 39, "", "", "", 43, 44, 45, 46, "", "", "", 50, 51, "", 53, "", 55, "", 57, "", 59, 60, "", 62, "", "", 65, 66, 67, "", "", "", 71, 72, 73, "", 75, "", 77, "", 79, "", 81, 82, 83, 84, "", 86, 87, 88, "", 90, "", 92, "", 94, 95, 96, 97, 98, 99;1, "", "", "", "", 6, 7, "", 9, 10, "", "", 13, 14, 15, 16, "", "", "", 20, "", "", "", "", "", "", "", 28, 29, "", "", 32, 33, "", "", "", 37, "", 39, "", "", "", 43, 44, 45, 46, "", "", "", 50, 51, "", 53, "", 55, "", 57, "", 59, 60, "", 62, "", "", 65, 66, 67, "", "", "", 71, 72, 73, "", 75, "", 77, "", 79, "", 81, 82, 83, 84, "", 86, 87, 88, "", 90, "", 92, "", 94, 95, 96, 97, 98, 99}), {1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; 13; 14; 15; 16; 17; 18; 19; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 40; 41; 42; 43; 44; 45; 46; 47; 48; 49; 50; 51; 52; 53; 54; 55; 56; 57; 58; 59; 60; 61; 62; 63; 64; 65; 66; 67; 68; 69; 70; 71; 72; 73; 74; 75; 76; 77; 78; 79; 80; 81; 82; 83; 84; 85; 86; 87; 88; 89; 90; 91; 92; 93; 94; 95; 96; 97; 98; 99; 100}))

becomes

MAX({9; 3; 5; 3; 7; 6; 6; 9; 8; 8; 7; 6; 9; 7; 5; 8; 5; 9; 3; 6; 9; 5; 7; 5; 5; 5; 5; 8; 7; 7; 5; 7; 9; 7; 4; 6; 8; 5; 7; 4; 5; 7; 10; 7; 9; 7; 6; 8; 6; 9; 7; 8; 7; 6; 8; 8; 7; 4; 8; 6; 8; 6; 6; 5; 11; 6; 5; 3; 5; 6; 4; 7; 6; 8; 8; 9; 6; 8; 7; 6; 5; 9; 6; 10; 5; 6; 8; 11; 5; 8; 7; 7; 6; 8; 9; 11; 8; 8; 8; 0; 0})

and returns 11.

Step 5 - Find position of most frequent row number

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), "")

becomes

IF(11=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), "")

becomes

IF(11={9; 3; 5; 3; 7; 6; 6; 9; 8; 8; 7; 6; 9; 7; 5; 8; 5; 9; 3; 6; 9; 5; 7; 5; 5; 5; 5; 8; 7; 7; 5; 7; 9; 7; 4; 6; 8; 5; 7; 4; 5; 7; 10; 7; 9; 7; 6; 8; 6; 9; 7; 8; 7; 6; 8; 8; 7; 4; 8; 6; 8; 6; 6; 5; 11; 6; 5; 3; 5; 6; 4; 7; 6; 8; 8; 9; 6; 8; 7; 6; 5; 9; 6; 10; 5; 6; 8; 11; 5; 8; 7; 7; 6; 8; 9; 11; 8; 8; 8; 0; 0}, ROW(\$1:\$100), "")

and returns

{""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 65; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 88; ""; ""; ""; ""; ""; ""; ""; 96; ""; ""; ""; ""; ""}

Step 6 - Find k-th smallest row number

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

becomes

=IFERROR(INDEX(List2, SMALL({""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 65; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 88; ""; ""; ""; ""; ""; ""; ""; 96; ""; ""; ""; ""; ""}, COLUMN(A1))), "")

becomes

=IFERROR(INDEX(List2, SMALL({""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 65; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; ""; 88; ""; ""; ""; ""; ""; ""; ""; 96; ""; ""; ""; ""; ""}, 1)), "")

becomes

=IFERROR(INDEX(List2, 65), "")

Step 7 - Return a value of the cell at the intersection of a particular row and column

=IFERROR(INDEX(List2, SMALL(IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)))=FREQUENCY(IF(ISERROR(SEARCH(MID(\$B2, ROW(\$A\$1:INDEX(\$A\$1:\$A\$100, LEN(\$B2))), 1), TRANSPOSE(List2))), "", TRANSPOSE(ROW(List2)-MIN(ROW(List2))+1)), ROW(\$1:\$100)), ROW(\$1:\$100), ""), COLUMN(A1))), "")

becomes

=IFERROR(INDEX(List2, 65), "")

becomes

=IFERROR(INDEX({"Lewis E. Charles ";"Young P. Nancy ";"Evans A. Thomas ";"Robinson C. George ";"Moore W. Thomas ";"Phillips M. Thomas ";"Moore T. Michelle ";"White X. Sandra ";"Evans O. Linda ";"Perez Y. Michael ";"Martinez U. David ";"Roberts H. Patricia ";"Taylor D. Anthony ";"Lee P. Thomas ";"Scott X. Paul ";"Moore O. William ";"Wright Z. Steven ";"Edwards P. John ";"Jones N. John ";"Johnson U. Paul ";"Edwards I. Sarah ";"Thompson J. Mary ";"Johnson Q. Richard ";"White W. Robert ";"Scott A. George ";"Baker E. Susan ";"Martin U. Jeff ";"Hall W. Jeff ";"Campbell B. Jennifer ";"Harris H. Sandra ";"Jackson R. Jeff ";"Collins D. George ";"Rodriguez F. Ronald ";"Rodriguez Q. James ";"Robinson X. Patricia ";"Parker P. Sarah ";"Evans N. Donald ";"Davis D. David ";"Scott C. Michael ";"Garcia O. Mark ";"Johnson V. James ";"Anderson F. Mary ";"Phillips V. Deborah ";"Davis V. Paul ";"Martinez G. Donald ";"Phillips C. Sharon ";"Robinson C. Sandra ";"Parker E. Richard ";"Green G. Sarah ";"Williams A. Sandra ";"Taylor B. Thomas ";"Parker D. Richard ";"Gonzalez Q. Laura ";"Martin Q. Kenneth ";"Martinez F. Elizabeth ";"Hernandez I. Richard ";"Allen Z. William ";"Thompson A. Jason ";"Baker S. Helen ";"Phillips O. Jennifer ";"Rodriguez N. Deborah ";"Miller U. Michelle ";"Moore I. Thomas ";"Rodriguez Z. Robert ";"Hall N. Edward ";"Lewis S. Robert ";"Phillips I. Ruth ";"Young R. Kevin ";"Harris U. Jason ";"Parker H. Steven ";"Nelson Y. Kevin ";"Wilson N. Anthony ";"Gonzalez T. Paul ";"Hernandez H. Sandra ";"Martin P. Helen ";"White X. Sandra ";"Moore T. Helen ";"Adams Y. Edward ";"Thompson B. Elizabeth ";"Thomas K. Margaret ";"Collins S. Susan ";"Campbell M. Ronald ";"Taylor B. Mary ";"Taylor G. Deborah ";"Moore A. James ";"Collins O. Anthony ";"Phillips L. Linda ";"Wright G. Daniel ";"Thomas N. Patricia ";"Jackson S. Charles ";"Thompson I. Richard ";"Campbell R. Kimberly ";"Brown J. James ";"Lee Y. David ";"Hill F. Richard ";"Wright E. Linda ";"Taylor I. Helen ";"Walker S. Kevin ";"Lee I. Sharon "}, 65), "")

becomes

=IFERROR("Hall N. Edward", "")

and returns Hall N. Edward in cell C2.

Fuzzy lookups.xlsx
(Excel 97-2003  Workbook *.xls)

### Functions:

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

MID(text, start_num, num_chars)
Returns the characters from the middle of a text string, given starting position and length

ROW(reference)
returns the rownumber of a reference

SMALL(array,k)
returns the k-th smallest number in this data set.

IF(logical_test,[value_if_true], [value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

ISERROR(value)
Checks whether a value is an error and returns TRUE or FALSE

SEARCH(find_text, within_text, [start_num])
Returns the number of the character at which a specific character or text string is first found, reading left to right (not case sensitive)