Looking for condition to ease at work

[Shaheryar_Ali]

I'm looking for condition/formula to lookup value while using filter on data. Right now what I was doing is coping a value from order column 'L' and pasting it to the upper right corner order cell in column 'AO' (green highlighted).

Example:

As show in the above picture to escape C&P, I'm want to use Condition/Formula on order value (upper right corner) to find same order value selected in selected from filter in table.

Could you please help me, which condition/formula should i apply to ease that problem.

[#2]

@Shaheryar_Ali 

Googled "find value of filtered cell excel" and found a formula that I got to work in a simple workbook of my own. Enter the following in "AO1" (assuming that the first row is indeed row 1 and that your column headers are in row 5) and it should work.

=INDEX(E:E,MIN(IF(SUBTOTAL(5,OFFSET(L5,ROW(L:L)-ROW(L5),0)),ROW(L:L)-ROW(L5)+5)))

[#3]

@Shaheryar_Ali 

IMHO, if the filter returns only one row, in AO1 it could be the formula like =L6 or so. Or you'd like to keep the value in AO1 after the filter is cleaned/changed?