How to make a lookup table in Excel

Vlookup in Excel is considered kind of tricky by most users. We will teach you how to apply vlookup. In the formula, you have to provide the cell where the results would be displayed, the data range, the column you are referencing it to and whether the condition is true or false. It is a logical function and helps people in real life situations when they are trying to maintain a car database or parts database.
In this tutorial, we will show you how to create a lookup table in Excel.


Step # 1 – Name your data range

When you are working with large amounts of data and want to find a specific row, you can use the lookup function.
First of all, give your data a name. Click anywhere on the data and press “ctrl + a”. Now go to the name bar and give it a name. In this tutorial, we have named it “Data”.

Give your data a name

Step # 2 – Insert Vlookup

In the video, we will start typing the function in cell “b8”.
Write =vlookup(a8, data, 2, false)
Now let us explain the vlooklup in Excel. In the tutorial, we have written A8 because that’s the code by which we will look up the data. “data” has been entered in the function because that is the name of our data range. Two is inserted for the second column “availability”. “false” is entered in the function at the very end because we want to find the exact match. If “true” was entered then it would have searched for a close match.

Apply Vlookup

Step #3 – Modify the Vlookup formula

Similarly for total the same function was used. However instead of writing “2” in the function, we have written “6” because “total” is in the sixth column.
Now whenever we change the value of cell “a8” in the tutorial, the results of “availability” and “total” are re-worked accordingly.

Make adjustment to the vlookup formula