The function VLOOKUP should be able to do that whether the list / value is
filtered or not.
"Eric" wrote:
Is there a worksheet function that can lookup the first value in a column in
a list that has been filtered?
In all cases the value will have been part of the filter, but done through
an autofilter (not an advanced filter).
Thanks, Eric
|