IF formula + 1 based on previous event

[correa.cristobal]

Good day, all

So, I have what seems to be a silly issue, but nor I nor an Excel expert in the office have been able to solve it "practically". Hopefully someone here has an approach that neither of us have thought of.

Let's say, for the purposes of this example, my worksheet consists of three columns (Condition, BonusCode VIPS and BonusCode ALL); what I'm looking for is to find a way for my bonus codes are numbered (1 on) depending on the last time that condition was met/used.

Let's say I have three rows with the same or different condition(s), for which the bonus codes should be the same (or dif, if another condition), but I want them to differ in the suffix number. I.E., VIPSPTRETAMBMARAB1,VIPSPTRETAMBMARAB2 and VIPSPTRETAMBMARAB3.

Notice in the example sheet these aren't necessarily one above/below the other, but rather separated by one or more row(s).

Any thoughts?

Thanks in advance all!

[ChemistB]

First, look up how to use VLOOKUP. I created a little VLOOKUP table which should contain all the possible things that could appear in Column A and their counterparts.

Then for formula for BONUSCODE All is

=VLOOKUP(A2, $J$1:$K$3,2,FALSE) &COUNTIF($A$2:$A2, A2)
copied down

[correa.cristobal]

Uh oh, I see what you did there! That did the trick! Thanks a lot!