Assumptions:

A2:C10 contains your data

E1 contains your lookup value

You wish to return the corresponding value in Column C

Formula:

=VLOOKUP(E1,IF(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10 )-MIN(ROW(A2:A10)),0,1)
),A2:C10),3,0)

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the
formula accordingly.

Hope this helps!

In article ,
"Bob B" <Bob wrote:

I want to autofilter a list and then run a vlookup based on the criteria
used. How do you reference the first cell of a filtered list?