I need to set up a file where I can enter a plot number in cell a1 (fixed
with freeze panes), have a range of plot numbers in column a and then
goto/jump to the relevant row for that plot in column b.

Suggestions appreciated..