Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Finding a cell and adding 1 to a cell in an adjacent column [Closed]

Report
-
 Blocked Profile -
I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to add. Each player has their own macro button that changes the name cell to the appropriate player. If Smith makes a basket, I click on his macro and his name is typed into A10. On the second page, I have the names of all the players in column 1 and all statistics I want to keep track of in row A. I'd like to create macro buttons for the statistics on the first page. Suppose I want to keep track of made baskets in column 2. Assuming I already have the players name in A10, I want to find that name in A1 on my stats sheet and add 1 to the value in column 2 (made baskets). Is this possible?
See more

1 reply

Answer 1 / 1

If your player name is the left most column, this is possible with Vlookup. Take a look here and let us know if you need help:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

It's kind of fun to do the impossible! -Walter Elias Disney
Ask a question