Referencing Table on Another Sheet

[StormStrikes]

I have a spreadsheet with two sheets in it.

Sheet 1 = sheet with formulas/functions for data analysis
Sheet 2 = sheet with table

I am trying to reference a column in the table on sheet 2 from sheet 1. Specifically, I am trying to set up Data Validation that will create a list of unique values from a column in the table. I tried:

Please Login or Register  to view this content.

There is a space in the header name of the column. but I was unable to get the validation to work even with columns that have just a single word name.

I also tried:

Please Login or Register  to view this content.

and that did not work either. What am I doing wrong?

[Miroslav R.]

Hi there,
You have to use INDIRECT:

Please Login or Register  to view this content.

(but You wil also have duplicates if there are any in Your table)

Does it work for You?

[StormStrikes]

That's freakin' AWESOME Miroslav. Thank you so much, I don't think I would have figured that one out on my own. Nothing in the google searches even remotely hinted at having to use INDIRECT.

[Miroslav R.]

You are welcome!
Happy that I could help!