VLOOKUP one of the topmost function of MS Excel, that is designed to work with data that is organised into columns. For a specified value, the function finds or looks up the value in one column of data, and returns the corresponding value from another column or database.
VLOOKUP work on the basis of find and search fundamental.

For More Details Please watch this video till the end.

Scrolling Chart-https://youtu.be/jaYlefumHmI

Advance VLOOKUP-https://youtu.be/WnE69GexpOY

Lookup Your Data Without VLOOKUP function
https://youtu.be/PMVqXU0nh24
https://youtu.be/VllDchr6WMI