FIND THE COLUMN REFERENCE FROM VALUE IN COLUMN

[Seeker After]

Hello All, I am attempting to create a data validation list box. The source formula should dynamically reference the column containing the DATE since the data set will be pasted in from time to time and DATE won't be in the same place each time. My attempts to this point has led me to this, =CELL("address",INDEX(A2:AZ1000,0,MATCH("Date",A2:Z2,0)))
This however only returns the cell reference. How can I specify the column starting with the first date?

 

[chirayu]

Can't seem to understand what you're actually referring to. All your dates are in Column A of Raw Data sheet. So what are you trying to find exactly? All the other columns are decimals. There are no dates in any other column.

Are you trying to create a dynamic dropdown that increases as you add more data in?

 

[Seeker After]

I am searching for a way to get the data validation list box source to search for the column that contains the dates and use the reference to fill the list box with the dates found there. Helps?

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Seeker After]

Ok Narayan how does this work this is great solution

 

[Seeker After]

Right, named range. Thanks.

 

[NARAYANK991]

Hi ,

You can check out the named ranges that have been defined.

Narayan