Multiple IF's & Index/Match - Not working properly

I am attempting to return an Index/Match result (from another worksheet "Depts & Codes), based on the text value in cell (D7) and cell (C18). The variable (or problem) seems to exist in D7 --- the value will be either "Temp" or "Active".

Based on the current formula I'm using (shown below), if D7 = "Temp", it returns the expected result, but if D7 ="Active", it returns "False" (not what I want).

=IF($C18="","",IF($D$7="Temp",INDEX('Depts & Codes'!$F$19:$F$50,MATCH($C18,'Depts & Codes'!$C$19:$C$50),IF(D7="Active",INDEX('Depts & Codes'!$D$19:$D$50,MATCH($C18,'Depts & Codes'!$C$19:$C$50,0))))))

I've also tried the following without success:
=IF($C18="","",IF($D$7="Temp",INDEX('Depts & Codes'!$F$19:$F$50,MATCH($C18,'Depts & Codes'!$C$19:$C$50,INDEX('Depts & Codes'!$D$19:$D$50,MATCH($C18,'Depts & Codes'!$C$19:$C$50,0))))))


The "Active" & "Temp" criteria is something new I've added to my original formula (shown below and in cell F24) - but I just can't get it to work properly with the new criteria.
=IF($C24="","",INDEX('Depts & Codes'!$D$19:$D$32,MATCH($C24,'Depts & Codes'!$C$19:$C$32,0)))

Am I missing something obvious? I've attached a sample of my workbook (note: I have links to another workbook, which may not properly function on your end - but I don't think this should affect the current issue)

Any help would be appreciated. Thanks so much!

Your inner IF does not have an action_if_false term, i.e.:

... IF(D7="Active",INDEX('Depts & Codes'!$D$19:$D$50,MATCH($C18,'Depts & Codes'!$C$19:$C$50,0)),action_if_false term here) ...

so that you can tell Excel what you want instead of FALSE.

Hope this helps.

Pete

Yup - that was it!! I knew it had to something simple (of course)!!!

Thanks so much (and yes, I feel like an idiot again!) LOL

Thanks Pete - actually daffodil11 provided the solution that seems to be working. I appreciate you looking at it and attempting to help. Much appreciated!