Is it possible to search use a regular expression in an array formula?
I have some defined values in cell A11 which works but I also want to lookup for example anything that starts with 4 numbers (which will represent a time code).
I have some defined values in cell A11 which works but I also want to lookup for example anything that starts with 4 numbers (which will represent a time code).
Code:
=IF(ISERROR(INDEX(employee_names,SMALL(IF(employee_1=$A$11,ROW(employee_1)),ROW(1:1))-1,1))," ",INDEX(employee_names,SMALL(IF(employee_1=$A$11,ROW(employee_1)),ROW(1:1))-1,1))