Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Need to increment a value in a list

  1. #1
    Guest

    Default

    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

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

    Default

    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
    Guest

    Default

    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
  •