Multiple Search Criteria IF(

[Aerofoam]

Basicaly I am trying to return any rows with part of the name "BOEING BACK", "BOEING BOTTOM", "BOEING HEADREST" within my IF(. Is there any way to simplify or modify where the formula says "BOEING BACK" to get all of these returns in one list? Please help if possible!


{=IF(ISERROR(INDEX(SPARES!$A$1:$O$300,SMALL(IF(SPARES!$A$1:$O$300="BOEING BACK",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2)),"",INDEX(SPARES!$A$1:$O$300,SMALL(IF(SPARES!$A$1:$O$300="BOEING BACK",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2))}

 

[barry houdini]

Hello Aerofoam, welcome to MrExcel

For all entries beginning with the text "Boeing" try replacing the parts

SPARES!$A$1:$O$300="BOEING BACK"

with

LEFT(SPARES!$A$1:$O$300,6)="BOEING"

 

[Aerofoam]

barry houdini you are an absolute genious and I thank you greatly! It worked like a charm.