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).
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.
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.