Looking for a way to look up any value from a range of cells in a different range of cells

I have a spreadsheet that contains hundreds of lines, where each line essentially has a bill of material for all components that make up that item. The first column has the master part number, and then the next 20+ columns have the item numbers of each component. I want to flag all the lines that contain certain item numbers, but they could appear in any of columns B-W. I played around for a while and essentially found three workaround solutions, but I feel there has to be a more simple way to make it work. A simplified version of the sheet is here:
Capture.PNG
Columns A-D have the various item numbers. E has a concatenate of the first four columns (necessary for solution 3). The three cells over to the right are the values I want to flag if present in any of the first columns. You can see my possible solutions in the first three lines. They all work, but is there a better way to look up any value from one range inside another range?

Edited

@ tim

Really?

8822421 is a first time poster. A little more attention to detail is in order. While there isn't a forum rule about this or uploading a workbook without adequate explanation the same considerations apply.

And BTW:
Hello 8822421. Welcome to the forum.

This appears to be an array formula. Array entered formulas are a little different from regular ones.
Here is the "canned response" I use when introducing them.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

You are welcome 8822421. Glad to help. Thank you for the feedback and marking your thread Solved.