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~!!