auto filling info into next column

[richpngu]

my boss is making me do an audit of of all the things that we use so i am trying to figure out a way for excel to auto fill information into the adjacent columns. so it would look like, A1 serial #, B1 name and C1 size of the item. A2, B2, C2 would have a different item and so on. the goal would be that when i am further down the list like A10, if i type the serial # from a previous row that it would auto fill B10 and C10 with the correct info. my knowledge of excels extends up to doing formulas so anything more advanced then that i would be completely lost.
thanks in advance.

[ARGK]

Hi
Can you post a sample of what you have and what you are after.
Tony

[richpngu]

here is a sample of what the spread sheet would look like. so if i were to type 55667788 in cell A11, B11 would auto fill bmw and C11 would auto fill green and then so on

[ARGK]

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