Searching specific text then validate in Excel?

I'm trying to figure out if this is possible. I have an excel spreadsheet with the following column

I want to validate/Compare the highlighted portion to an Xlookup column I have

I'm trying to validate line by line that what I see in column N highlighted matches column BD highlighted. It only needs to match one of the highlighted items. I am attempting to filter this down by using =IsNumber(Search but that only goes so far.

Is there any formula, or even VBA code that could compare and validate to se if what's in Column N is also in Column BD? Any help on this would be GREATLY appreciated.

So to get the text up to, but not including, the first space, I would do:

=left(A1,find(" ",A1,1)-1)

Then you could use that to do a vlookup:

=vlookup(left(A1,find(" ",A1,1)-1),range-to-look-in,2,0)

But you could look in column 1 as well.