Thank you Pecoflyer & Xor. Both solutions WORKED! you guys are awesome

Two questions tho:

1. The solution from Xor worked but seems abstract to me, because it doesn't include the use of cell B2. Kindly explain your formula?

2. In my example cell B2 contains the cell address $A$2, which i arrived by using the formula (=ADDRESS(MATCH(A2,A:A,0),COLUMN(A1)). i wanted to use the cell address $A$2 in B2 to find the answer. Can this be achieved?


Thanks again. Awaiting your responses.