My vlookup formula no longer works, I think it may be something to do with
the fact that the data is no longer in sequential order e.g. 1, 2, 6, 5 and
there are cells in the range that are blank.

Surely there must be a way around this? Is there a way to get the vlookup to
work properly without putting all the rows in sequential order?