MATCH - find values in a range <> another range

Hello,

I have a list of data on sheet 1. I the use a formula to get the data into a table on sheet 2.

=INDEX('Sheet 1'!AC17:AC700,MATCH(1,INDEX(('Sheet 1!AB17:AB700=A8)*(Sheet 1'!AC17:AC700<>"Result")*('Sheet 1'!AC17:AC700<>O8)*('Sheet 1'!AC17:AC700<>O9)*('Sheet 1'!AC17:AC700<>O10),0,1),0))

Is there any way that I could condense the last part of the formula (in red text) so that it is something like:

*('Sheet 1'!AC17:AC700 <> O8:O10)

I have tried the above but it doesn't return any value is there a way to do this sort of thing?

Thanks

Hello allan, try

ISNA(MATCH('Sheet 1'!AC17:AC700,O8:O10,0))

That works great - thank you very much

Hello

Thanks to help already I have been able to create a formula that picks a value from a list that matches multiple criteria:

=INDEX(D2:D5,MATCH(1,INDEX((C2:C5="A")*(D2:D5<>""),0,1),0))

Up until now there has only ever been a need to return one value.

This has now changed and it is possible that multiple rows will meet the criteria so I need to modify this formula to caclulate the total of all items that match the same criteria.

Any help would be much appreciated.

Thanks