Help with this text identification formula

I'm working on a simple text identification project.

Currently, the formula is

=IF(H11="N/A","",IF(H11="",IFERROR(INDEX({" M1"," M2"," M3"," M4"," M5"," M6"," M8"," M10"," M12"," M16"," M20"," M24"," M30","Screw","BSW","Bolt","Nut","Washer","Head","Countersunk"},MATCH(TRUE,ISNUMBER(SEARCH({" M1"," M2"," M3"," M4"," M5"," M6"," M8"," M10"," M12"," M16"," M20"," M24"," M30","Screw","BSW","Bolt","Nut","Washer","Head","Countersunk"},A11)),0)),""),H11))

As you can see there is a lot of text,

Is there any way to remove the text and replace it with just a cell value which has that text written in it. This is so I can make an adjustment to the text parameters easier.

I've tried using an indirect function but this doesn't seem to work.

Thanks

Hi

I have attached the basic document,

the long text join within building blocks sheet is where I want to take my text value from.

Thanks

Hi,

Is there a way to add the function so if the list increases in size it can automatically adapt the code, maybe via an indirect and count function?

Other than that is works great, thanks

This has been a great help, its working really well now.

Is there a way to make this have two lists which can act as an AND function, so a value from list A and value from List B must both be present for it to function. Is this complicated or just a simple and function between the current expressions with an extra list.

Thanks

Here is the file,

Basically, instead of one list, I want two lists of data which can mix and match with each other, if that makes sense

Thanks