Can't read VLOOKUP and IF when combined? Understand long formulas through 'shop conversations'

Hello, this is Wanosuke 🐊I understood VLOOKUP somehow. I could also use IF if I took it one by one.Yet, the moment I combine ...