Compare two columns and get result from third

Hi all.. hope you are all well... PFA.

I need to compare two columns and get the result from third column. Attached is the example information I am looking for.

If there are multiple matches then it has to go by ascending order and display the results in Ascending order.

From the attached:
1. Compare B & C and if they Match Provide A2
2. Consider "Who" in B2 and B10
-- It should first compare with first "Who" in C4 and provide respective A4 - as 4
3. Then "Who" in B10 should search for its match after C4 only and bring that match - like
-- B9 & C10 match now - result should be 9

There might be multiple same values in Column B & C but then it has to go based on ascending order and provide the next value but not consider the first.

Any help is appreciated.

Regards,
R

Hi Glenn... Sorry for the confusion... here is the detailed explanation and new doc attached....

1. Compare B & C columns. so, C2 is "Where" .. look for "Where" in Column B .. There is a match(C9). so .. In Column E1 I need the result as 1(which is in A9). So it compares C2 value with all vales in B Column and gives the result at first Match.

2. Similarly, Compare B & C columns. C3 is "What". look for "What" in Column B. There are 2 matches basically(B2 & B11). In Column E2 it should provide the result as 1(which is in A2 as the first match).
Now, again Compare B & C columns. C6 is "What" again. Now this time It should start looking for match in Column B by ignoring the first "What" in Column B2 and search further up. Then we do have a match in B11. so, the result in this case is 10.

So, if there is a match already found then the next time if it appears it should ignore the first match and start searching again.

Hope I am clear now. Attached updated Doc. Please ignore the previous attachment.

Regards,
R

Thanks much for the quick reply Glenn... appreciate it...

Will check it out tomorrow and confirm.

Regards,
R