yes no or count how many times a value appears

Hi,

In column K of sheet 1 I want my function to lookup the data in sheet 3 and tell me if there is a match or not and count how many occurences there are of the print ISBN (column e of sheet 1)

The highlighted rows on both sheets match by print ISBN but there's something wrong with my function as it tells me there is no match.

Can the MATCH function handle multiple values in a cell? See J12 in sheet 3 where two ISBN 10's occur separated by a ;

Thanks very much in advance.

Hi Bo_Ry - thanks for replying. The second function looks very clever but I can't fathom it. The first one looks like it is aiming to count the occurrences but it doesn't do that for my data but that could be my inexperience.

Could I simplify my request and just ask for help to return 'yes', 'no' whether it's finding the ISBN in the second sheet or not?

Thanks for your patience

That's perfect - thank you so much!