Ok, i have this forumla

(Array)
=IF(ISNUMBER(MATCH("b",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500),0)),INDEX(StaffData!$A$5:$A$497&" "&StaffData!$B$5:$B$497,MATCH("b",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500),0)),"none")

It filters to see if "SCOE" as well as then matching it....

I need it to check for SCOE OR SCOEBOTH.

I was trying something like this...

(ARRAY)
=IF(ISNUMBER(MATCH("a",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500), IF(StaffData!$C$5:$C$100 = "SCOEBOTH",StaffData!$N$5:$N$500,0))),INDEX(StaffData!$A$5:$A$497&" "&StaffData!$B$5:$B$497,MATCH("a",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500),IF(StaffData!$C$5:$C$100 = "SCOEBOTH",StaffData!$N$5:$N$500,0))),"none")

It feels like it should work! but its not :(
Any help would be greatly appreciated.

You appear to have the syntax of the MATCH functions a bit off. I edited your formula to insure the EXACT MATCH freature was being utilized. Please try this version of your formula:

=IF(ISNUMBER(MATCH("a",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500), IF(StaffData!$C$5:$C$100 = "SCOEBOTH",StaffData!$N$5:$N$500),0)),INDEX(StaffData!$A$5:$A$497&" "&StaffData!$B$5:$B$497,MATCH("a",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500),IF(StaffData!$C$5:$C$100 = "SCOEBOTH",StaffData!$N$5:$N$500),0)),"none")

Regards,
Frank

Woot. It works now. I had to rearrange some of the ( )'s to get it working but it works like a charm now. Woohoo:)







=IF(ISNUMBER(MATCH("a",IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500, IF(StaffData!$C$5:$C$500 = "SCOEBOTH", StaffData!$N$5:$N$500)), 0)),INDEX(StaffData!$A$5:$A$497&" "&StaffData!$B$5:$B$497,MATCH("a", IF(StaffData!$C$5:$C$500="SCOE", StaffData!$N$5:$N$500, IF(StaffData!$C$5:$C$500 = "SCOEBOTH",StaffData!$N$5:$N$500)),0)),"none")


Thanks a ton.

-Bryan