INDEX MATCH problem

[ollyhughes1982]

Hi,

I have the following formula:

=IFERROR(INDEX('All Completed Runs'!$C$4:$C$2003,MATCH("*"&"United Kingdom"&"*"&"*"&A4&"*"&"<>1",'All Completed Runs'!$D$4:$D$2003&'All Completed Runs'!$C$4:$C$2003&'All Completed Runs'!$FL$4:$FL$2003,0),0),"")

The first two parts work fine, but the third search won't work. This third criteria should look in column ref 'All Completed Runs'!$FL$4:$FL$2003 and if there is a 1 in there not show a value. If there is not a 1 then the value should show. (if there is a 1 in 'All Completed Runs'!$FL$4:$FL$2003 then it is a restricted even and shouldn't be included).

Column ref 'All Completed Runs'!$FL$4:$FL$2003 displays as either blank ("") or a 1, according to the formula in that column.

Is there something about the <>1 that is not right? is it nor possible to do a 'not equal to' search within INDEX(MATCH?

Thanks in advance,

Olly.

 

[Fluff]

Glad to help & thanks for the feedback.