Data Validation & Define Name & Indirect function

Start your defined names with a letter (e.g. "A"), then in your DV formula you can have:

=INDIRECT("A" & C1)

assuming C1 is where you make your (numeric) choice.

Hope this helps.

Pete

Is there a way that I could hide the "A" (or other letter) so that wouldn't show up in the dropdown?

It shouldn't show in the drop-down - you should only get the numbers displayed, and when you choose one the INDIRECT formula adds the A onto the beginning of the number. If this is still not clear, attach a sample workbook so I can set it up for you.

Hope this helps.

Pete

I still having trouble figuring it out. I have attached a sample workbook if you could help that would be great! Thanks!

You were nearly there, but you had a defined name of A_1110 although the value in C4 was 1100. Change the named range to A_1100 and then you will see the three values from column D of the NamedValues sheet shown in the drop-down in C5. Obviously, you then need to add several more named ranges of this type, depending on the choices that you can make in C4.

Hope this helps.

Pete

Thanks, that works. If not for that typo it would have worked before but your help is much appreciated!

Glad to help. Thanks for feeding back, and a Happy New Year.

Pete