Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding OR to an index match formula | Excel Worksheet Functions | |||
index, Match statement | Excel Worksheet Functions | |||
adding AND, OR to excisting INDEX formula | Excel Discussion (Misc queries) | |||
Sum within an Index Match Statement | Excel Discussion (Misc queries) |