Need to increment a value in a list
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Need to increment a value in a list

  1. #1


    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...


  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Westwood NJ
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    You mean that you want Carol's value to change to 6?

    If so, do you want to change that value to 6 in the MyList range? Or where? VLOOKUPs return values, the do not change values.

    ~Anne Troy

  3. #3


    Exactly - I need to increase carol's number to six.

    Vlookup locates correct number now how can I refer to that cell (and change its contents to 6)?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts