Trying to increment cells after checking other cells
Hi guys,
I'm not the best at Excel and have found something that I can't figure out.
Basically I'm trying to make it possible for a value to entered into one cell eg B2, then check a table for that value and after finding the value increment the number in the cell next to it (found in cell a12, add 1 to cell b12).
Even if you guys just tell me Excel won't work for what I'm trying, that will be a help to be. I'm just unsure how to make it work the way I'm trying to.
Thanks in advance for any help :)