I want to reference the cell in the list (AC69-AC91) not E71.

For what purpose? Does this mean you want the cell address? Do you want to
use the address as a reference in a formula?

--
Biff
Microsoft Excel MVP


"AFJr" wrote in message
...
Hi,

I have a dropdown from a validation list. I want to reference the cell
that
the list is pointing to.

Ex. my list where the dropdown is located is E71, the list is located at
AC69 and is 23 rows. When an item is selected from the list, I want to
reference the cell in the list (AC69-AC91) not E71.
--
TIA

AFJr