Dynamic Range Graph Update - Help!

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!

Thanks for your reply rorya.

I have updated the formula to this: =OFFSET(INDEX(EFF,MATCH($G$2,'2018'!$C:$C,0),8),0,0,1,53) and its working like a champ. Can a dynamic named range include an IFERROR()? I noticed when I type an employee ID that does not exist I am given the same error.

I ended up adding IFERROR instead of using data validation. I've basically designed a form where you type in the employee ID and it pulls various info from a raw data worksheet. My last step was the graphing for a better "visualization" or trends. Thanks so much for your help!