PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
The function is very specifically meant for the situations such as:
STEP 4:
After clicking the gkxlookup, the first window will open asking for the value or values to be looked up.
The field asks for the value or values to be looked up.
The following ways can be used to enter the value.
STEP 5:
After entering the LOOKUP VALUES, the next input field asks for the lookup array that is, the array from which we want to lookup the value.
We can select it on the sheet itself.
STEP 6:
The next option is select the Range for the return array or table. It can be a column or a range.
STEP 7:
The last option is to put the TEXT or MESSAGE which must be displayed if the values are not found.
Let us take the example of a coded language with the following codes.
We have two tables with some information about the different employees.
Table 1 contains the details like Employee id, employee name and employee location.
We got some additional information about the employees which is given in Table 2 shown below.
Table 2 contains additional employee details like Employee age and employee overtime.
We need to create a final table in which Table 1 contains all the information in a single table.
TABLE 1
EMP ID | EMP NAME | EMP LOCATION |
1011 | DENIS | PARIS |
1021 | LEANDER | NEWYORK |
1030 | FRIDRICK | LONDON |
3021 | JOJO | PARIS |
4520 | JJ | LONDON |
8745 | KEVIN | PARIS |
6541 | CHUCK | DELHI |
3254 | CASPER | MOSCOW |
Few more information came through an email and contained the following table.
TABLE 2
EMP ID | EMP AGE | OVERTIME |
1030 | 25 | 12 |
3021 | 23 | NA |
4520 | 26 | 13 |
8745 | 27 | 15 |
3254 | 29 | 17 |
6541 | 25 | NA |
1011 | 24 | 42 |
1021 | 25 | 12 |
The first step to solve the problem is to create two more columns EMP AGE and OVERTIME in the first table i.e. TABLE 1 as shown in the picture below.
Enter the column name as EMP AGE and OVERTIME in the first table as shown in the picture above.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE