Now you could select the range in your lookup table and make it absolute by adding dollar signs, or simply enter the name you created for it. Since we need to get book titles for all the IDs we have here, begin with a reference to the cell with the key value: A2. There is one prerequisite that will make your work a lot easier: select the lookup values starting with your key column and enter a name for the range into this box. Here we have the book IDs and authors and we need to look up the book title in another sheet. Now that you know the basics, let's try a different example and consider some more details.
Let's take a quick look at the formula to read it: find this city in the first column of this range and return the corresponding Zip Code from the third column there when you find an exact match. Even though this argument is optional, remember to include it to avoid unexpected results.
if you wanted to find the city name by the ZIP code, you'd simply enter it as it is.
Let's look at the structure of the formula to get a better understanding of what it needs to work. The structure of the VLOOKUP function in Excel Here is a quick example: you have a list of addresses and cities, and you can quickly pull the corresponding ZIP codes from the reference table.
Vertical lookup is what you need when you have interrelated information in different Excel tables. In this video we will explore the Vlookup function.