Listing the named range values

[Schofi_D]

Hi All

Im getting a bit lost on what im trying to do here

I have the named range value in Cell D5 and this range changes dependant on other dropdowns, which then creates a data validation list in a tabular from im building, but i want to build a summary table where the list of values in that named range is already populated in a table

example: D5 says "ACREST_DOM" which is the named range

That range has 7 entries which are
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Employee 6
Employee 7

In my summary table which starts in cell AG8 i want the first value "employee 1" listed and then the cells below list the next value in that range, as the range changes in cell d5 the list in the summary table will change too

How do i do this? i have tried, index, match, offset but all i keep getting in AG8 is ACREST_DOM rather than what is in that range

Thanks

Dan

 

[Jerry Sullivan]

Hi Dan,

You can try this formula. Paste it into AG8, then copy down as many rows as the maximum number of items you will have in the named ranges.

=IFERROR(INDEX(INDIRECT($D$5),ROW(AG8)-ROW(AG$8)+1),"")