Numbers lookup giving wrong results

Hi... Having converted everything in sight to Apple, now using Numbers for first time (having been conversant with Excel).

The Lookup function is driving me crazy. I'm asking the formula to look at a cell in the current sheet, find the same value in a column on another sheet, and display the value given on that sheet in a different column to the current cell. But when I test what I've done the results are all over the place. The aim is to find if an exhibitor in our Flower & Produce Show has their random exhibit number listed as a winning entry in the results sheet, and if so display either 3, 2 or 1 points depending on whether their number appears in the 1st, 2nd or 3rd place column.

Here's the formula in cell M3. Right result, but given I've got the same formula in all the other cells in column M, other than the cell first looked up, why am I getting the same results in all the column cells? I've only entered '34' once in the table being looked up. All the other cells are blank.

And why, for the same formula in N, do I get some cells showing a correct error message and one showing '2'?

And finally for column O, I get mostly '1's and one correct error message. Any help much appreciated! Thanks, John