referencing autofilter result

[EH003268]

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

[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)

EH003268 wrote:
> I need to have a cell display the value of a cell selected in an
> autofilter (it will always show only 1 result). My list (autofiltered)
> has only 1 column.
> Thanks
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[EH003268]

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