From: Steve on
I've now tried vlookup and it too isn't giving me what I'm looking for.
My eq arrangement is:

=VLOOKUP(SUBTOTAL(109,range),range,1,FALSE)