Adding another if statement to an index formula
Hi All,
New Here, so hoping you can help.
I have designed an engineer scheduling template, but now need to add to the main fomrula that schedules the jobs by engineer.
I have the following formula which froma large list extracts the 1st job by engineer that is an inspection (not a mini).
IFERROR(INDEX('Region 2 Raw Data'!$K$1:$L$340,SMALL(IF(('Region 2 Raw Data'!$K$1:$K$340=A5)*('Region 2 Raw Data'!$O$1:$O$340<"MINI"),ROW('Region 2 Raw Data'!$K$1:$K$340)),ROW($1:$1)),2),"")
What i now need is to add the data from another coloumn which will have either a C or blank, so the formula will only bring back those jobs that have a C in this coloumn.
I hope this makes sense
looking forward to your help
Donna
|