Multiple Search Criteria IF(

Aerofoam

New Member
Joined
Jun 16, 2011
Messages
4
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! :confused:


{=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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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

New Member
Joined
Jun 16, 2011
Messages
4
barry houdini you are an absolute genious and I thank you greatly! It worked like a charm.
 

Forum statistics

Threads
1,086,122
Messages
5,387,973
Members
402,091
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top