Need to increment a value in a list

Mar 11th, 2002, 05:27 PM

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

Anne Troy · Mar 11th, 2002, 05:31 PM

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.

Mar 11th, 2002, 05:56 PM

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

Mar 11th, 2002, 05:31 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 05:27 PM	#1
Guest Posts: n/a	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

Mar 11th, 2002, 05:56 PM	#3
Guest Posts: n/a	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)?