I am using Data Validation. The list source is on the same (main) worksheet.
The validation criteria is Allow: List, with In-cell dropdown.

Thanks.
--
Rubble


"Toppers" wrote:

Is the drop-down list using Data Validation? Or is a Combo box?

"Rubble" wrote:

Hi,

I have a worksheet that I am using to summarize information from another tab
in the same workbook (file). I need to display the contents from a drop-down
list (i.e. what ever value has been selected from the list) from the main tab
in the summary tab. However, when I use the standard =(maintab)'cell
reference formula, the cell gives me a #VALUE error mssage. How can I solve
this?

Appreciate any help.

Rubble