Struggling with VLookup

[JoeyEE]

Part of my coursework is to explain and use VLOOKUP functions, yet i cant seem to understand what it is or how it works. Could someone give me an easy to understand explanation as well as an example?

[#2]

@JoeyEE 

This explains it very well in my opinion and there are multiple examples.

VLOOKUP function - Microsoft Support

[#3]

yeah i read that and im still struggling :\
one of my teachers struggles with it too, so that says enough about it lol

[#4 · Accepted solution]

@JoeyEE 

Perhaps you can share a practical example of VLOOKUP which causes a problem or maybe this link is helpful.

Excel VLOOKUP function | Exceljet

[#5]

the thing is, i dont have any data that im supposed to use, i need to make it up. The task of the assignment is explaining how to use VLOOKUP but i dont even know how to use it myself