nathanthomson11
New Member
- Joined
- Apr 4, 2019
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I have the following formula that I'd like to wildcard the word "Seats" (Highlighted in red), although I don't believe the FILTER formula supports wildcards. I'm guessing the answer is ISNUMBER/SEARCH of some sort but can't figure it out..
=IFERROR(SUM(FILTER(FILTER('Customer Release (Daily)'!$H$2:$AN$499,'Customer Release (Daily)'!$H$1:$AN$1=C6),ISNUMBER(MATCH(LEFT('Customer Release (Daily)'!$C$2:$C$499,7)&"*",FILTER('Material Breakdown'!$C$2:$C$499,'Material Breakdown'!$B$2:$B$499="*"&" Seats"),0))))+SUM(FILTER(FILTER('VL06 (Next week)'!$G$2:$G$499,'VL06 (Next week)'!$G$1="Delivery Quantity"),ISNUMBER(MATCH(LEFT('VL06 (Next week)'!$D$2:$D$499,7)&"*",FILTER('Material Breakdown'!$C$2:$C$499,'Material Breakdown'!$B$2:$B$499="*"&" Seats"),0)))),0)
=IFERROR(SUM(FILTER(FILTER('Customer Release (Daily)'!$H$2:$AN$499,'Customer Release (Daily)'!$H$1:$AN$1=C6),ISNUMBER(MATCH(LEFT('Customer Release (Daily)'!$C$2:$C$499,7)&"*",FILTER('Material Breakdown'!$C$2:$C$499,'Material Breakdown'!$B$2:$B$499="*"&" Seats"),0))))+SUM(FILTER(FILTER('VL06 (Next week)'!$G$2:$G$499,'VL06 (Next week)'!$G$1="Delivery Quantity"),ISNUMBER(MATCH(LEFT('VL06 (Next week)'!$D$2:$D$499,7)&"*",FILTER('Material Breakdown'!$C$2:$C$499,'Material Breakdown'!$B$2:$B$499="*"&" Seats"),0)))),0)