Member-only story
VLOOKUP is a powerful function in Excel used to search for a value in the first column of a table and return a value in the same row from a specified column. It stands for Vertical lookup because it searches vertically down the column of a table.
VLOOKUP can be a bit tricky for a beginner to use, so I have devised a demonstration of how to use it. The example that I am presenting below is one that I use in my day to day duties.
The scenario that I have created is the data from a training set, which will be used for data in an appraisal set.
I have initially set up the id numbers, which in this instance, are numbered 1 to 20. In order to create the id numbers in sequential order, I have entered 1 in cell A2 and the formula =A2+1 in cell A3. I then copied the formula down to cell A21:-
I have then entered the name of the person, the team he is a member of, and whether the training is complete.
In order to create the appraisal sheet, I simply entered the id numbers in reverse order. In cell G2 I entered the largest id number, being 21. In cell G3 I entered the formula =G2–1. I then…
