Forum Discussion
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...
It sounds like you are adding the formula but it's not auto-filling down the entire column of the table? If this is the case, if you have a value below or a different formula in the column below, the auto-fill will not take the formula down to the bottom of the column automatically.
- That's not the case. It's when I add a new entry to the table. I use the Form in Excel. It fills in all the variable information. The IFS commands are moved to the new record but none of the Indsex commands are entered into the new record. Those cells are blank.
