#Sample excel query table code

After we click on the Relationships option, in the beginning, since there is no relationship, hence we will have nothing. So firstly, we shall go to the Data tab and then select Relationships in the Data Tools subgroup.

Now we need to do the same process for the lookup table as well and name it Shelf Code.

In our example, we have named the table Personnel.

While still focused on the new table, we need to provide a name that is meaningful in the Name box (towards the left of the formula bar).

In our example, it does indeed have a header.

Uncheck or check the My Table has the Header option.

Click the Insert tab and navigate to Table in the Tables group or simply press Ctrl+T.

So, it might be necessary sometimes to convert data sets to table objects.

Now, the Data Model is only compatible with table objects.

As we can see from the data, it is possible to create a relationship based on common columns.

The table on the left is the data table, and the table on the right is the lookup table.

So how do we incorporate the shelving descriptions against each shelving code? Perhaps many of us would resort to using VLOOKUP here, but we shall altogether remove the need to use VLOOKUP here using Excel Data Model.

We need a table where we have the shelving description along with the shelving codes.

#Sample excel query table code

We have a list of products, and we have a shelving code for each product.You can download this Data Model Excel Template here вЂ“ Data Model Excel Template Example #1