G
Guest
Guest
I am new to macros/excel
I am trying to use vlookup to increment (by 1) a value (using help in excel has left me frustrated beyond belief)in the next column
ie list is
bob 3
mike 4
carol 5
steve 2
= VLOOKUP(C1,myList,2,FALSE) c1 has "carol"
so this returns 5 now I want to increment to 6 and place back into carol's row- this seems like it should be so very easy to accomplish and yet...
Thanks
I am trying to use vlookup to increment (by 1) a value (using help in excel has left me frustrated beyond belief)in the next column
ie list is
bob 3
mike 4
carol 5
steve 2
= VLOOKUP(C1,myList,2,FALSE) c1 has "carol"
so this returns 5 now I want to increment to 6 and place back into carol's row- this seems like it should be so very easy to accomplish and yet...
Thanks