Renee,

Here is a little solution to your question that will get you started.
If you haven't used these before, I recommend you start with VLOOKUP.

Your first sheet would look like this, with the drop down selections
(datavalidationlist) in columns A to C. Column D would bring them all
together to give you a unique identifier.

ColA ColB ColC ColD ColE
aa ee ii =A2&B2&C2 =VLOOKUP(D2,Sheet2!A:B,2,FALSE)
bb ff jj =A3&B3&C3 = VLOOKUP(D3,Sheet2!A:B,2,FALSE)

Sheet2 would look like this, for all the possible combinations from your
first sheet:

ColA ColB
aabbcc $29.34
bbffjj $12.64
aaccee $36.28
aaeeii $32.16

For the first row on the first sheet, the VLOOKUP will pull in the value for
aaeeii ($32.16, remember to do cellsformat it as dollars). For the second
row it will pull in the value for bbffjj $12.64.

Hope that helps you get started.
--
Allllen


"Renee in SC" wrote:

Nothing like trying new things! I have to admit I am trying to push myself to
learn a little more. I havn't used VLOOKUP, INDEX or MATCH before. Any advise
to things to watch out for?

"Ed" wrote:

Yes that is possible to do in Excel, I guess it would mean some nested IF's,
AND's, OR's and SUM functions... Other way that I think about is maybe the
value picked returns a value with a VLOOKUP, INDEX, MATCH, etc function and
then the sum of those for or so? depends what specifically want to do...