Index/Match/Match Will Not Update When Adding Additional Information

[bberry86]

I am working on creating a table that shows the most recent survey information for each project area. On my display page i have the current formula type of

=IF(A4="-","-",INDEX('Erosion and Sediment'!A$3:A$1999,MATCH($A4,'Erosion and Sediment'!$B$3:$B$546,0),(MATCH("Newest",'Erosion and Sediment'!$P$3:$P$1999,0))))

When i update the Erosion and Sediment sheet with a new survey with a more current date the table will not update.

Any help would be greatly appreciated.

When i originally created the table it seemed to be working and gave me
[TABLE="width: 2775"]
<tbody>[TR]
[TD="class: xl67, width: 204"]Gas Blowout[/TD]
[TD="class: xl65, width: 45"]63[/TD]
[TD="class: xl65, width: 204"]Gas Blowout[/TD]
[TD="class: xl65, width: 297"]0[/TD]
[TD="class: xl65, width: 155"]0[/TD]
[TD="class: xl65, width: 130"]0[/TD]
[TD="class: xl66, width: 165"]8/12/2016[/TD]
[TD="class: xl65, width: 76"]2016[/TD]
[TD="class: xl66, width: 242"]5/6/2016[/TD]
[TD="class: xl65, width: 141"]Minor rills on the south end (previously recorded), moderate sediment deposit behind gravel bags. [/TD]
[TD="class: xl65, width: 192"]-[/TD]
[TD="class: xl65, width: 178"]Remove sediment buildup after next rain event. [/TD]
[TD="class: xl65, width: 168"]No maintenance recommended at this time. [/TD]
[TD="class: xl65, width: 201"]0[/TD]
[TD="class: xl66, width: 236"]-[/TD]
[TD="class: xl65, width: 50"]0[/TD]
[TD="class: xl65, width: 91"]Old[/TD]
[/TR]
</tbody>[/TABLE]

But when i added a new survey to the bottom of the table with a newer date the display table would not update i have tried the CRTL ALT F9

 

[arthurbr]

Is what you call a table, just a list or is it a table in the way Excel sees it ( created with the Insert - Table tool) ?

 

[bberry86]

Is what you call a table, just a list or is it a table in the way Excel sees it ( created with the Insert - Table tool) ?

Would be a list, I can attach or send file if needed

 

[arthurbr]

OK. Then just select a cell in your list, go to the Insert ribbon, click Table and follow the instructions.
Now each row you add will be automatically calculated as the previous one