auto filling info into next column

Hi
I have created a lookup table in Sheet2 which you will need to populate with all your variations.
Then I have created a Vlookup formula in columns B and C. So when you ntype the Serial Number in column A the Make and colour will automatically populate.
The formulas go down to row 25, just copy them down as far as you need.
Hope this helps.
Good luck.
Tony