I have a filtered list in excel and say the first row of filtered data was A400. how can I do a lookup against this first cell. Obviously every time I filter against a different part nmber the first row changes.

macke