Difficult Lookup formula [Closed]

Report
-
Posts
15657
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
May 18, 2021
-
Hello,

I have a difficult question that may not have an answer. At least, I haven't found a formula that works.

A B C
1 RC002 RC003 RC004 1 3

2 RC005 RC006 2 4

3
A B C
4 RC002 RC004 2 4
5 RC003 2 4
6 RC005 RC006 3 5

As you see, RC003 is no longer grouped with RC002 RC004 in the bottom part in column A
Column B indicates how many times Item in column A (RC002 RC003 RC004) has appeared. For this example, In the top part it arrears once. In the second part, it now has appeared twice.
Column C calculates consecutively it has appeared. For example in the top part, RCOO2 RC003 RC004 is at 3, but in the bottom part, RC003 no longer is in that group, but they were in the top part, so in column C, RC003 should be 3. If I use the vlookup(RC003 (A7), A1:C3,3,True, I would get 4 instead of 3.

This is pretty difficult to explain, and I'm sure I didn't explain myself well.

1 reply

Posts
15657
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
May 18, 2021
5
It is hard to help based on what you provided.
You do not describe clearly what is in each cell of your sheet.
Instead of "top part" and "bottom part", I suggest you use line numbers.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!