Vlookup and pivot tables

I would suggest not only looking at several videos, but also--even more important--taking on the task of creating a spreadsheet following the examples in those videos and creating your own. You may have done that, I realize...but you're asking us to do what the videos do after telling us they haven't helped. In layman's terms "you're asking for what you've declared won't work."
You also might try some non-video sources. Here's a good one. But create your own examples and work along with the instruction. THAT IS how to learn it. https://exceljet.net/search?query=pivot+table
https://exceljet.net/search?query=vlookup
Once you've mastered VLOOKUP, you might want to research further. XLOOKUP, for example, is more powerful (and newer)