Normally, I don't use vlookup in this pattern.
Your formula (vlookup) were placed on 'Gavain query for HMC' but first parameter was come from another sheet ( 'HMC O365 License Order' ) and looked data from 'Gavain query for HMC'.

I'm always place the formula in the same sheet of first parameter's sheet.

Regards.