I have a simple template that I am trying to set up to do an analysis on our
profit for a line of business. In column A11 am using a Code (BL, EP, PB
etc) that will affect the value of the cell in column G12. Ths value is not
the same for each of the codes in A11. What "simple" formula can I use to
accomplish this. I am guessing I will need a type of validation or lookup
but don't know the proper procedures. Thanks

BG
--