The link below has some solutions;
https://exceljet.net/formula/vlookup-with-numbers-and-text
TL;DR,
=IFERROR(VLOOKUP(id,planets,3,0),VLOOKUP(id&"",planets,3,0))
Brain-dumps and useful information for my reference but published in case anyone else finds it useful.
=IFERROR(VLOOKUP(id,planets,3,0),VLOOKUP(id&"",planets,3,0))