Adding another if statement to an index formula

I

Icehockey44

Hi All,

New Here, so hoping you can help.

I have designed an engineer scheduling template, but now need to add t
the main fomrula that schedules the jobs by engineer.

I have the following formula which froma large list extracts the 1st jo
by engineer that is an inspection (not a mini).

IFERROR(INDEX('Region 2 Raw Data'!$K$1:$L$340,SMALL(IF(('Region 2 Ra
Data'!$K$1:$K$340=A5)*('Region 2 Ra
Data'!$O$1:$O$340<>"MINI"),ROW('Region 2 Ra
Data'!$K$1:$K$340)),ROW($1:$1)),2),"")

What i now need is to add the data from another coloumn which will hav
either a C or blank, so the formula will only bring back those jobs tha
have a C in this coloumn.

I hope this makes sense

looking forward to your help

Donn

+-------------------------------------------------------------------
|Filename: ADDING TO INDEX.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=743
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting data from database into separate sheets 0
IF statement with multiple VLOOKUPs 0
IF Then statement or another function to look for a value 2
How to add in an array formula if iisna index match 4
incorporate the remove #DIV/0! code into another formula to get bl 5
VBA for index match and an IF statement to make a cumbersome formula easier 2

Top