Okay that was click bait. Vlookup is merely bad. Ohhh the controversy. Intermediate Excel Lesson time. I’ve tried putting plenty of pictures to explain but tbh it’s so much easier just to download the sheet and play along. So click here and do that. I’ve used Vlookup for years , in a million spreadsheets. A million? Literally a million ? Yes. You are ridiculous and I refuse to engage with you further.