Issue with nested Or statement

[MikeSta4ord]

Hi I'm having trouble with the formula I'm using. I want it to return information depending on criteria from another sheet. The criteria is that the concluding followup row OR the initial followup row has to have "yes" in order for the data to be transferred. For some reason that I cannot identify, It's returning every single row to the sheet when I input this formula.

=IFERROR(INDEX(Table5,SMALL(IF(OR(Table5[Concluding Followup]="YES",Table5[Initial followup]="Yes"),ROW(Table5[Offer '#])-MIN(ROW(Table5[Offer '#]))+1,""),ROWS($1:1)),MATCH(B$1, 'Proposal log'!$A$1:$P$1,0)),"")

Though without the "Table5[Initialfollowup]="Yes" portion it works fine but only returns the rows with concluding followup as "yes".

Can anyone identify the problem? If not I'll post a sample file.

Thank you.

[DBY]

Hi
I think it might be difficult to identify the problem from the formula alone. A sample file would help enormously in clarifying the fault.

DBY

[MikeSta4ord]

Here's the sample file. Column B in the Emails sheet contains the error I'm describing.

Thank-you

[DBY]

Take a look at the attached file. I've amended the Array formula you were using on the Emails tab. Does this do as required?

[MikeSta4ord]

Yes, that's exactly it.

Thanks for clearing that up, I'm still learning the intricate elements for formulas within excel.

Best regards