CODEWITHSUNDEEP
excelvalidationdrop-down-menu
Benjamin Calvert
Benjamin Calvert

Reputation: 11

excel data validation from sheet name based on cell value?

I'm trying to make drop down menus in an excel project and I want to adjust the source of menu items to be based on the value of another cell in the sheet.

I thought I could do this using something like =INDIRECT(C2)! Which I believe would select the sheet named whatever the value of cell C2 was. so if C2 contained the word Days. then it would select the sheet Days! but this isnt working.

Ive created an example file that will hopefully show what i want to acheive GoogleDrive

Upvotes: 1

Views: 40

Answers (1)

Scott Craner
Scott Craner

Reputation: 152605

INDIRECT takes a string and returns a range reference.

you must concatenate the whole reference as a string:

=INDIRECT("'"&C2&"'!A1")

This will return the range of A1 on the sheet named in C2.

Upvotes: 0

Related Questions