INDEX MATCH where lookup array is multiple columns

Hi,
I've done extensive searching and not found something that matches my scenario.
I suspect it requires an array formula but I can't work out how to build it.

I've attached my example file.

I have used an INDEX MATCH formula to return a value from column 1 when the code in column 2 matches the inputted code.
However each returnable value has multiple codes attached to it that are held in columns 2 through 6.
I need the formula to look for the code in columns 2 through 6 not just in column 2.

Is there a formula or work around for this?

Thanks so much all.

Helper column was a good idea. But the other formula suggested works exactly as I had hoped and intended.
Thank you so much - I do hope this solution is helpful to others also.