I use autofilter to apply criteria to an initial pool to get an eligible pool for sampling.

I then copy the filtered data (unhidden) to a working sheet, and use vlookup on a third "summary sheet" that obtains data from the working sheet.

I am trying to figure out had to get the vlookup function to ignore hidden rows so I can do away with the "working sheet"

is there any way to get functions to ignore hidden rows/data?