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