VLOOKUP is a ‘must know’ for any Digital Shelf Manager and will save you HOURS AND HOURS of trawling through data if you don’t already know it.

Perhaps you know a product code, but need to enter the products title and price – a VLOOKUP quickly finds the data you are looking for and enters it where you need it! If you don’t already know this and you use excel, you need to learn this…

How to Create a VLOOKUP in Excel

Click the cell you want to enter your VLOOKUP into

(This is where the data will be returned)

👇

Start your formula by typing =VLOOKUP(

👇

Click the cell containing the data you want to ‘look up’ information for followed by a comma and a space

👇

Now select the column that you want to find this data in (this could be in a different spreadsheet) and drag across to the column you want to return the data for.

(IMPORTANT: The column you want to find the data in must come BEFORE the column containing the information you want to return)

👇

Comma space (you don’t actually need the space but it looks nicer 🙂)

👇

Type in how many columns away from the first column the information you want to return is in – If your first column is A and the value you want to return is in column C, this would be 3…A, B, C = 1, 2, 3. (If you have a lot of columns, make it easier by finding the number in the little box that pops up when you are dragging across – it is the number just before the C)

👇

After the number, add your comma space and type FALSE).

👇

(Want to know a secret? We still don’t know what happens if you put ‘TRUE’ 🤔)

👇

Your cell should now contain the values you were looking for!

👇

Click the bottom right corner of the cell containing your VLOOKUP and drag down (or double click!) to copy for all cells in that column

👇

That’s it!

Congratulations… You’ve just saved HOURS of your life 🎉 (… you’re welcome!)