How to find names in a column from a smaller list of names in another column, plus mark for sorting

[itsMonty]

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

[#2 · Accepted solution]

@itsMonty 

In B1:

=IF(ISNUMBER(XMATCH(A1, $D$1:$D$11)), "fix", "")

Adjust $D$1:$D$11 if necessary.

Fill down.

[#3]

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.