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