Can I use an IF function to Autofill?

Hello everyone,

I have a simple IF function, but I would like to have the value if false auto-fill from the line above, is that possible? I've looked around the forum but I can't find anything.

In context, we receive orders from the night before, if they have the same PO number I would assign them the same order number (alpha numeric - Otherwise I could just put the previous cell +1) as the order above, but if they have different PO numbers it would autofill to the next order number.

So, my IF statement would look something like this (with the auto-fill part of the false value being incorrect - obviously since that's my question):

IF(G3=G2,C2,AUTOFILL(C2))

Thank you!

How about:

Formula:

Please Login or Register  to view this content.

Is first part always 2 characters?
If so:

Formula:

Please Login or Register  to view this content.

this is obvious:

Formula:

Please Login or Register  to view this content.

then instead of just (as in post #2)

Formula:

Please Login or Register  to view this content.

we have

Formula:

Please Login or Register  to view this content.

two leftmost characters of text in C2

Formula:

Please Login or Register  to view this content.

concatenation
with

Formula:

Please Login or Register  to view this content.

middle part of value (string) in C2 starting from character 3 and having all remaining characters (total length - 2 leftmost we used before)

Formula:

Please Login or Register  to view this content.

This last part is text, but containing only digits, so as we made (1+this string it is treated by excel as a number and incremented by 1.