David I would list the text "Bob's Sales" to come from the drop down list. I
want the value in cell Sheet1 B2 to change each time another name is selected
from the drop down list.

"David Billigmeier" wrote:

Use as the cell reference the following code:

='Bobs Sales'!D5


--
Regards,
Dave


"DB" wrote:

Is there a way to use the "value" of a name in a drop-down list to reference
a sheet tab name in a formula?

A1 has a drop down list. When a name (Bob's Sales) is selected from the
drop down list, B1 shows the value of cell D5 from sheet "Bob's Sales".

Thanks for your help!!