referencing autofilter result

E

EH003268

I need to have a cell display the value of a cell selected in a
autofilter (it will always show only 1 result). My list (autofiltered
has only 1 column.
Thank
 
D

Debra Dalgleish

If it's a column of numbers, you could use the Subtotal function to show
the selected cell. For example, with your list in column A:

=SUBTOTAL(9,A:A)
 
E

EH003268

Thanks for the reply but
My list is text only. i want to use the selected cell for a vlookup in
another worksheet.
 
Top