Hi Adam,

How are you referencing your first vlookup cell in your second vlookup?
If you address the cell directly you will get an error but not if you
address
it as VALUE().

So your second formula would be something like
=VLOOKUP(VALUE(K17) etc....etc...

HTH
Martin