Hi,
some short questions.

Assume that also Tom Jones has a value of 30 in cell F3. How shall the formulas react if you enter 30 in cell B9? (since both Tom Jones and Ian Gilbee are vald answers in cell A9). Could the answer be any of those two?

Is it possible that you enter "33" in cell B9, and like to get the answer "Peter Jones" in cell A9 (although he has another value, like 70, which is higher)?

What result would you like to have in cell A9 if a zero is entered in cell B9?

Should the formulas in A10+B10 works in exaclty the same way as the formulas in A9+B9?

Regarding "not changing the layout", is it allowed to add any formulas on a separate worksheet OR below the data (line 15 and below)?

Best regards
Bjorn