Column needs to adjust value/text based on value in other cell.

[Krikemancer]

Hi there

I'm trying to make our work a little easier by making some shortcuts.

Now the problem:

e.g.

If cell B3 contains "VC" then cell H3 should have the value "401", and so on. (402, 403, 404, ...)
If cell B3 contains "MKE" then cell H3 should have the value "35000", and so on. (35000, 35001, ...)

All data is in one table, but H3 should start counting from the top if B3 changes.

Making the IF funtcions is no problem, but I have no clue how to "reset" the counting.

Right now, if I add a different value in B4 (other than B3) it should be changing to 35000 or 401 based on the text in B4.
But it just keeps counting, so I end up with 402 or 35001.

I'm at a loss.


Help would be greatly appreciated.

Greetings

Krikemancer



Attachment: Test.xlsx

[Pete_UK]

Put this in H4:

=IF(B4=B3,H3+1,IF(B4="MKE",35000,401))

then copy down.

Hope this helps.

Pete

[Krikemancer]

Thanks for the reply.

Sadly it didn't work :/

[Pete_UK]

It did for me - see attached file.

You probably need to use semicolons instead of commas in the formula.

Hope this helps.

Pete

[Krikemancer]

It does work now. I indeed missed the semicolons

Thanks a lot!


Krikemancer

[Pete_UK]

Right, I'm glad we sorted that out.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete