Modify Order Number Column based on Zip Code Column

[gshowman1]

Is there a way to add an incrementing value to the end of the order number column based on the zip code? (see the embedded image below, rows 1 through 12). In other words, for each zip code, we want to modify the order number by adding a "-1", "-2" etc.

I would like it to look like the sample I provided in the embedded image below (rows 15 through 26). Is there an easier way other than manually doing this? It would be helpful when I have hundreds of line-items to modify.

Thanks in advance!

Attachment 668135

[torachan]

Rather than the zip code it looks as if you already have part of the answer with the Store number ???

[gshowman1]

The actual store numbers have a different format than the way we have order numbers. For this batch, each different zip code must have the same order number but with a suffix added of a "-1", "-2", "-3", etc (as I have shown in my manually changed order numbers listed on rows 15 - 26).

[torachan]

You could do it with a simple looping macro.
Attached example, you need second sheet as reference to store zip/suffix

[avk]

As per torachan, =A2&"-"&RIGHT(B2,2)
But you mentioning store number in different format.
Can you attach actual sample workbook. For clearity.

[gshowman1]

After discussing with the person I am helping, this formula is the ideal solution for us.


Thank you and torachan for your responses. Much appreciated!

(In my original post, I changed the image to an excel file.)