Next Higher Number in series matching particular criteria

Hi,

I was looking of next higher number in a series where value matches in another column.

In the list below, Column 1 and Column 2 are the data entries and Column 3 is the desired output.

Which formula can be used for this?
The need is to find the next higher number in the Column 2 where Column 1 value matches.
Sequence cannot be put in ascending or descending order for both Column 1 or Column 2.
If there is no higher value in column 2, same value is required as output in Column 3

A 8 12 A&">8"
C 7 18 C&">7"
A 3 8 A&">3"
B 2 2 B&">2". No such value. Hence output as 2 itself.
B 2 2 B&">2". No such value. Hence output as 2 itself.
B 1 2 B&">1".
C 5 7 C&">5"
A 12 12 A&">12". No such value. Hence output as 12 itself.
C 18 18 C&">18". No such value. Hence output as 18 itself.

Thanks.

Dear Flame Retired,

Thanks. The file I shared was illustrative and I have to use for a bigger application where the second and third columns are dates actually.

I am not very familiar with array functions but I suppose, I will be able to use it in my application very well.

Thanks once again.

Thanks a lot.

The formula worked wonderfully in the file on which I was working.