Return specific numbers from a chart depending on drop down box selection

I am trying to create a "recipe" for stains. I have a drop down box for the major colors and i have a chart of the minor colors needed to create those colors. I need a formula that will take the drop down selection and lookup the necessary amounts of minor colors needed to create the major colors.

Assuming you have a matrix (table) where:

Column-1 = list of major colors
All columns to the right contain associated minor colors

And if this table is in the range of, say, M1:Pxx (for major and three minor colors)

If cell A1 contains the drop down list, then in say, A3, we could use this formula

=VLOOKUP($A$1,$M$1:$P$10,COLUMN(),FALSE)

Drag the formula across the B and C columns.

Obviously, if you have more than three minor colors, adjust the formula as required.

It's not too hard to understand. Start by reviewing the Excel Help on the VLOOKUP and COLUMN functions.

VLOOKUP(A,B,C,D)

A = value to look up
B = range of cells to look in ( must be left-most column in the table)
C = which column in the table to return a value if a match is found
D = look up type (exact match or approximate)

COLUMN() - simply returns the column number of the active cell and in the formula I gave this is used as a variable for "C". If the formula is in cell A3 and we drag the formula from A3 to C3, column would return 1,2,3 respectively for columns A, B, C