Thank you to those who suggested setting the range lookup to FALSE. This has fixed it.
=VLOOKUP(F74, (INDIRECT($K$3)),2,FALSE)