Hi,

I need help on how to compare two list. The Blue Column (MMO) is the Master List, and I used XLOOKUP command (and even tried nesting them) to compare two columns. Due to potential spelling errors and/or missing word(s) like shown in the picture (green highlight) it’s not picked up by the exact search so I also used small, larger, wildcard categories as well. My issue now is I can’t individually check down the column because there are too much, 4000 names down the list, and it will take too much time. How do I go about checking them without resorting to brute forcing myself? I reckon it would require chains or nesting commands, but I can’t solve it.

Thank you in advance for help, and have a good day!

EDIT: Can share the excel file via Onedrive if needed.

​Hi, I need help on how to compare two list. The Blue Column (MMO) is the Master List, and I used XLOOKUP command (and even tried nesting them) to compare two columns. Due to potential spelling errors and/or missing word(s) like shown in the picture (green highlight) it’s not picked up by the exact search so I also used small, larger, wildcard categories as well. My issue now is I can’t individually check down the column because there are too much, 4000 names down the list, and it will take too much time. How do I go about checking them without resorting to brute forcing myself? I reckon it would require chains or nesting commands, but I can’t solve it. Thank you in advance for help, and have a good day!  EDIT: Can share the excel file via Onedrive if needed.  Read More

​