Hi I have the following array formula:
={IFERROR(SMALL(IF(MATERIAL!$C$2:$C$556480=$A$1,IF(MATERIAL!$N$2:$N$556480=$A$2,
ROW(MATERIAL!$C$2:$C$556480)-ROW(MATERIAL!$B$2)+1)),ROWS($A$4:A4)),"")}
This currently works perfect only now I have to search for non exact matches eg.
Current i am searching for all instance of A2=M001
A2 how ever can be M101 or and combination of digits it will however always begin with the character M.
Does anyone know how to modify the array formaula to return all instance if begins with "M".
Many thanks in advance!!
I think will involve search & including wildcard - unsure of this
Bookmarks