OFFSET Function not extending to new rows

[adubblenie]

Hello,
I am trying to add more rows to my chart, but when I extend the rows with the formulas I am getting " ##### " instead of the numbers I'm expecting.


Here's my formula that starts the chart:
=OFFSET('Raw Data'!$A$6,Performance!$B6,MATCH(Performance!E$5,'Raw Data'!$6:$6,0)-1)

Here's the formula in the bottom row:
=OFFSET('Raw Data'!$A$6,Performance!$B38,MATCH(Performance!H$5,'Raw Data'!$6:$6,0)-1)

Here is a screenshot of 'Performance':
http://imgur.com/Gv0TmMJ

And here is a screenshot of 'Raw Data':
http://imgur.com/fOriqWJ



Any help is great help! Thank you!

-Annmarie

 

[bbott]

Welcome to the board.

Have you tried to widen your columns? Usually, the #### appears when a cell's content is larger that the cell.

 

[adubblenie]

Thanks for your quick response!
I extended the columns per your suggestion, but it appears the numbers aren't correct, and they're all the same in each column... see link below for a screenshot.

Imgur