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)?

Some videos you may like

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