Forum Discussion
Solved
How to find names in a column from a smaller list of names in another column, plus mark for sorting
Hello all. To demonstrate (screenshot enclosed), I have a list of names in column A and a smaller list in column D. Is there a formula that can be placed in column B to find the matching names ...
In B1:
=IF(ISNUMBER(XMATCH(A1, $D$1:$D$11)), "fix", "")
Adjust $D$1:$D$11 if necessary.
Fill down.
In B1:
=IF(ISNUMBER(XMATCH(A1, $D$1:$D$11)), "fix", "")
Adjust $D$1:$D$11 if necessary.
Fill down.
- Perfect! Is there nothing excel can't do? Not to mention the helpful community for always having an answer. This worked great. Thank you for responding so quickly, it is much appreciated.
