J
JeffJ
I want to choose a selection from a drop-down
list, then type in an amount in a nearby cell,
and I want it to find the matching row of the
item I chose from the drop-down list and enter
that amount into that row (and add it to any
amount that is already there, because that cell
will already have a formula in it, and I want to
add to that formula).
For ex., let's say Column A has labels.
A1, A3 and A5 are labelled "Rafter." A2, A4 and
A6 are labelled "Amount."
A9:A13 are labelled "5001":"5005", respectively.
These represent the various names/types of the rafters.
B1:B6 require a selection or manual entry from the user.
B1, B3 and B5 are existing drop-down lists (corresponding
to the "Rafter" labels; the Data Validation settings for
the drop-down lists reference A9:A13).
B2, B4 and B6 are blank cells with no formulas that
allow *any* number/amount to be typed in by the user.
A9:A13 already have formulas in them, and these formulas
return amounts based on a combination of several different
factors.
But now I want to add another formula(s) to A9:A13 that
says, basically:
"Find the corresponding row (in B9:B13)
of the Rafter that I've chosen from any of the drop-down
lists (in any or all of B1, B3 or B5);
then, add whatever amount I have typed
(in any or all of B2, B4 or B6),
to any amounts already existing in B9:B13."
I'm guessing that possbily VLOOKUP, INDEX (Reference),
or possibly MATCH, or a combination of these, may
provide a solution.
Thank you for any help or replies.
Jeff
(e-mail address removed)
http://lightningfingers.tripod.co
list, then type in an amount in a nearby cell,
and I want it to find the matching row of the
item I chose from the drop-down list and enter
that amount into that row (and add it to any
amount that is already there, because that cell
will already have a formula in it, and I want to
add to that formula).
For ex., let's say Column A has labels.
A1, A3 and A5 are labelled "Rafter." A2, A4 and
A6 are labelled "Amount."
A9:A13 are labelled "5001":"5005", respectively.
These represent the various names/types of the rafters.
B1:B6 require a selection or manual entry from the user.
B1, B3 and B5 are existing drop-down lists (corresponding
to the "Rafter" labels; the Data Validation settings for
the drop-down lists reference A9:A13).
B2, B4 and B6 are blank cells with no formulas that
allow *any* number/amount to be typed in by the user.
A9:A13 already have formulas in them, and these formulas
return amounts based on a combination of several different
factors.
But now I want to add another formula(s) to A9:A13 that
says, basically:
"Find the corresponding row (in B9:B13)
of the Rafter that I've chosen from any of the drop-down
lists (in any or all of B1, B3 or B5);
then, add whatever amount I have typed
(in any or all of B2, B4 or B6),
to any amounts already existing in B9:B13."
I'm guessing that possbily VLOOKUP, INDEX (Reference),
or possibly MATCH, or a combination of these, may
provide a solution.
Thank you for any help or replies.
Jeff
(e-mail address removed)
http://lightningfingers.tripod.co