If v looking up a list of numbers what if my lookup value is duplciated?

vlookup looks for a unique value and returns a relevant piece of data.

You would need something that makes the value unique, like a specific pupil ID

if your values are all duplicates, you should make your own little unique reference.

something like a date entered combined with the order number would be good by usig the concatenate() function.