I don't know if this can be done or not.... I have one cell B4 that is a
dropdown list through data validation. Then another cell, A15, that looks at
B4 and performs a vlookup to find a value. Lets say it is currently filled
with 2 based on 'Team A' being selected in B4.

But, I need to change that value based on another drop down list at D15. I
need to now change the value in A15 based on what is selected in D15.

In other words, the value in A15 will remain at 2, unless an alteration to
equipment is made through the drop down list in D15, (Ex: "Exchange 1-Wood
Bat for 1-Metal Bat"). Now A15 should show 1 instead of 2. BUT.... should
show 2 unless an option (and there are about 7) is chosed in D15.

I also need to change a new cell, A20, from 2 to 3 because I removed 1 wood
bat and added a metal bat.

Does this make sense??? HELP!!

Many, many thanks in advance~!!

Maybe something using IF & 2 vlookups to check on the 2 DV cells' selections
made in B4 & D15 in sequence, would suffice for the desired functionality?

Example, in A15:
=IF(B4="","",IF(D15="",VLOOKUP(B4,{"Team A",2;"Team B",3;"Team
C",4},2,0),VLOOKUP(D15,{"Opt1",1;"Opt2",2;"Opt3",3 ;"Opt4",4;"Opt5",5;"Opt6",6;"Opt7",7},2,0)))

The above essentially presumes D15's selection will "override" B4's
selection for the value to be returned in A15, viz.:

If B4 = blank (ie nothing is selected/cell B4 is cleared), it returns a
blank: ""
If B4 = Team A & D15 = Opt1, then it returns the vlookup on D15, ie: 1
If B4 = Team A & D15 = blank, it returns the vlookup on B4, ie: 2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"lost and confused in excel-land" wrote:
I don't know if this can be done or not.... I have one cell B4 that is a
dropdown list through data validation. Then another cell, A15, that looks at
B4 and performs a vlookup to find a value. Lets say it is currently filled
with 2 based on 'Team A' being selected in B4.

But, I need to change that value based on another drop down list at D15. I
need to now change the value in A15 based on what is selected in D15.

In other words, the value in A15 will remain at 2, unless an alteration to
equipment is made through the drop down list in D15, (Ex: "Exchange 1-Wood
Bat for 1-Metal Bat"). Now A15 should show 1 instead of 2. BUT.... should
show 2 unless an option (and there are about 7) is chosed in D15.

I also need to change a new cell, A20, from 2 to 3 because I removed 1 wood
bat and added a metal bat.

Does this make sense??? HELP!!

Many, many thanks in advance~!!

It would, but i needs to return different values based on the multiple
combinations. I couldn't get that formula to work for me.

I wouldn't use the named data range for the Options? I'm new at this, and
really appreciate the help!!


"Max" wrote:

Maybe something using IF & 2 vlookups to check on the 2 DV cells' selections
made in B4 & D15 in sequence, would suffice for the desired functionality?

Example, in A15:
=IF(B4="","",IF(D15="",VLOOKUP(B4,{"Team A",2;"Team B",3;"Team
C",4},2,0),VLOOKUP(D15,{"Opt1",1;"Opt2",2;"Opt3",3 ;"Opt4",4;"Opt5",5;"Opt6",6;"Opt7",7},2,0)))

The above essentially presumes D15's selection will "override" B4's
selection for the value to be returned in A15, viz.:

If B4 = blank (ie nothing is selected/cell B4 is cleared), it returns a
blank: ""
If B4 = Team A & D15 = Opt1, then it returns the vlookup on D15, ie: 1
If B4 = Team A & D15 = blank, it returns the vlookup on B4, ie: 2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"lost and confused in excel-land" wrote:
I don't know if this can be done or not.... I have one cell B4 that is a
dropdown list through data validation. Then another cell, A15, that looks at
B4 and performs a vlookup to find a value. Lets say it is currently filled
with 2 based on 'Team A' being selected in B4.

But, I need to change that value based on another drop down list at D15. I
need to now change the value in A15 based on what is selected in D15.

In other words, the value in A15 will remain at 2, unless an alteration to
equipment is made through the drop down list in D15, (Ex: "Exchange 1-Wood
Bat for 1-Metal Bat"). Now A15 should show 1 instead of 2. BUT.... should
show 2 unless an option (and there are about 7) is chosed in D15.

I also need to change a new cell, A20, from 2 to 3 because I removed 1 wood
bat and added a metal bat.

Does this make sense??? HELP!!

Many, many thanks in advance~!!

I wouldn't use the named data range for the Options?

Ah, the hardcoded table references: {"Team A",2;...} were just incidental in
the example expression. You could of course use named ranges or direct cell
refs instead.

Coming back to your core issue:
.. but it needs to return different values based on the multiple combinations.

One possibility would be to frame all the different combinations up clearly
in a table, then read-off values from this table using index/match. Maybe
other responders would chime in here with other ideas for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---