Hey guys,

Had an issue with trying to get a named dynamic range to auto update on a bar graph.

Named range = rekt, formula = OFFSET(INDEX(EFF,MATCH(G2,'2018'!C:C,0),8),1,1,0,53).

Basically I want the dynamic range be from '2018'! matching employee ID # (G2) from column C:C, then go to the matched row and select from column 8 to 60. However this does not seem to work and gives me a #REF error. I was able to add the dynamic range but it shows as {...} in the name manager window and when I attempt to use it in the graph using 'tracker'!rekt I get "Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

I've been banging my head against a wall for a little while now trying to figure out why the dynamic range isn't working and any help would be greatly appreciated!