00:00imagine this you have two tables one for project and the other one to hold the names for the
00:06assistant to the regional manager here and the field that bridges these two tables would be the
00:12employee id with all that out of the way if you have to fill up this particular table with details
00:19from project tables and the assistant to the regional manager this is how you do it by the way
00:25in the world of sql or sql it is called relational database query we're going to start off with using
00:32a vlookup function the first argument would be the project id and the second argument will be the
00:40project table itself the idea of the first vlookup is to get the employee id so that i can use
00:46the
00:47employee id to get the details of the assistant to the regional manager so i'm going to press f4 here
00:53so that it's fixed because we're going to apply the vlookup formula to the rest of the rows shortly
00:58after here the third argument on this first vlookup would be the column index itself so it's going to
01:04be one two three employee id is number three so we're going to say three here like this
01:08and the fourth argument we're going to say exact match like this close parenthesis and hit enter
01:13and as you can see this returns the employee id that's associated with the project id skybridge
01:20upgrade now you're going to encapsulate the output from this vlookup which is the employee id with
01:26another vlookup basically nesting it like that and the second vlookup will take the input of the
01:34employee id from the first vlookup comma and then you're going to use that employee id against the table
01:42from the assistant to the regional manager table here you're going to press f4 to make both row and column
01:48fixed because like i said you're going to apply the same formula to the rest of the row shortly after
01:53and the third argument we need name region and salary which is column number two three and four
02:00you can do that by putting a curly braces and say column two comma three comma four close curly braces
02:07this is going to return the three columns that we have highlighted here two three and four
02:13and the fourth argument for the vlookup we're going to say exact match like this comma we're going to say
02:20false for exact match close parenthesis and hit enter as you can see the employee id 6686 which is emma
02:27from texas this is the salary is being withdrawn from the or rather looked up from the assistant to the
02:34region manager table here now you can apply the same formula to the rest of the row like this and
02:39you can see that
02:39based on the employee id from the project you get the details of the employee from the second table
02:46which is the assistant to the regional manager here after that you're done
Comments