Slide 2:
Our list or table array Data will be put here
using VLOOKUP
Slide 3:
We start writing our Vlookup function.
Note the parameters or arguments that
the function needs to give the correct answer
Slide 4:
We wish to lookup a value in cell
c2 from the table or data from the
range of cells G2:H4
Slide 5:
Now we define the column in the
table array from where we wish to pick up the data. The column under ‘Grade’ is defined as 1 and the column under ‘basic salary’ is defined as 2.
Slide 6:
The range_lookup is a true or false value
that indicates whether the columns of the
Table array are sorted or not. In our case the
columns are not sorted.
Slide 7:
Because our table array G2:H4 is not sorted
We select ‘FALSE’ . We aim to find an ‘exact’
match for our lookup value
Slide 8:
Vlookup has found an
exact match of 20000 for us.
Slide 9:
Now we define our array from G2:H4 to
$G$2:$H$2. This is also known as
Absolute cell reference.
Slide 10:
The absolute cell referencing
gives the correct result when
we now do an ‘autofill’.
Slide 11:
Thanks for watching!
For any other queries or videos log on to
familycomputerclub.com or email
exceltraining@familycomputerclub.com