Tools for Information Literacy
VLookup Function
We used the VLOOKUP function earlier when we discussed functions, but there is an even more useful LOOKUP.
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table.
It is an Excel way to do what SQL can do with a relational database.
Here's a more extensive discussion, one which connects VLOOKUP with relational databases
What is XLOOKUP?
To quote an excellent source on the topic ...
XLOOKUP is everything VLOOKUP is and much more.