FootBallBat
Board Regular
- Joined
- Jan 26, 2012
- Messages
- 169
Im looking for a VBA code that works like Vlookup.
Lookup data= A:B
(D1) is a dropdown list of A:A
(E1) is a manual input of a number.
When the Macro is ran, I want it to search for (D1) in column A:A and increase the amount in the corresponding B:B column by the amount in (E1).
<tbody>
</tbody>
Lookup data= A:B
(D1) is a dropdown list of A:A
(E1) is a manual input of a number.
When the Macro is ran, I want it to search for (D1) in column A:A and increase the amount in the corresponding B:B column by the amount in (E1).
A | B | C | D | E |
Bronze | 12 | Gold | 3 | |
Silver | 6 | |||
Gold | 10 | |||
Platinum | 4 | |||
<tbody>
</tbody>
Last edited: