Excel Vlookup


Today blog post I want to dedicate an Excel function that easily goes well to non experienced Excel users by the hand and saves time.

 

With the VLOOKUP formula, one can compare two databases on a key together and link.

 

In our example, we use two practice tables on sodas. We want to import in the Table 1, the color of lemonade, which is stored in table 2.

 

Target Table 1, here we would like to fill the column C with data from Table 2:

Today blog post I want to dedicate an Excel function that easily goes well to non experienced Excel users by the hand and saves time.

 

With the VLOOKUP formula, one can compare two databases on a key together and link.

 

In our example, we use two practice tables on sodas. We want to import in the Table 1, the color of lemonade, which is stored in table 2.

 

Target Table 1, here we would like to fill the column C with data from Table 2:

 

Table 2, here is the color attribute, which we want to load in the column C in Table 1:

 

In cell C4 now comes in the destination table following formula:

= VLOOKUP (A4; Table 2 A: B; 2; WRONG!)

 

The values ​​are in brackets (each in the formula of Excel visible helper) for the following:

 

A4 = search criterion, for this value is sought in the table 2

 

Table 2 A: B = Matrix, the range in which to search for the value and where the target value (here column A to B)

2 = Column index, I.e. in which column counted from the beginning of the matrix, the result is (here in the second column B)

false = false is only one value if the search criterion is found exactly true brings back the value which is most similar to the search criterion

 

Now you can this formula by double-clicking the black dot at the bottom right of the cell C4, simply copy down in C5-C7 and get the following result:

 

Together with the knowledge of the F4 function to disable cell, you can create as superfast linked tables.

 

Table 2, here is the color attribute, which we want to load in the column C in Table 1:

 

In cell C4 now comes in the destination table following formula:

= VLOOKUP (A4; Table 2 A: B; 2; WRONG!)

 

The values ​​are in brackets (each in the formula of Excel visible helper) for the following:

 

A4 = search criterion, for this value is sought in the table 2

 

Table 2 A: B = Matrix, the range in which to search for the value and where the target value (here column A to B)

2 = Column index, I.e. in which column counted from the beginning of the matrix, the result is (here in the second column B)

false = false is only one value if the search criterion is found exactly true brings back the value which is most similar to the search criterion

 

Now you can this formula by double-clicking the black dot at the bottom right of the cell C4, simply copy down in C5-C7 and get the following result:

 

Together with the knowledge of the F4 function to disable cell, you can create as superfast linked tables.

Print Friendly, PDF & Email

Leave a comment

Your email address will not be published. Required fields are marked *