I was hoping someone could offer me a little help please on a formula. In one of my cells I use a vlookup to search for the colour in B12 and match it to the colour on another worksheet called cars.

Now this works perfectly fine, but after running the formula I have to select the last row of data and press control & d, or drag down the cell up until the last cell, my question is that is it possible to add this formula into the cell and have it automatically run all the way down to the last row of data? my formula is

Code:
=VLOOKUP(B12,coloursc:carsc,2)