Forum Discussion
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 of col. A & D and place text "Fix" in the corresponding B cell?
My objective is to sort the sheet by column B, so that all the rows that need fixing are listed together. My real list has 600+ rows. I am hoping to save time and work.
In the image the names in purple demonstrate the matching titles.
I appreciate any assistance.
cheers
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.
