Excel Index and match works but does not append.

I have the table set up and the command itself works. When I add a record to the table, all the other commands append the table and fill in the information. The Index Match commands do not. What am I...