I have one table which lists a trailer number, the section of the yard in which it is parked, and then the row inside the parking spot (TrailerList). I also have a table which will show visually where the trailer is parked based on this list (TrailerPark). I have it set to auto-populate the trailer name from TrailerList into the correct location in TrailerPark using the formula =IFERROR(INDEX(TrailerList[[Trailer]:[Trailer]],MATCH(1,(TrailerList[[Section]:[Section]]=”A1″)*(TrailerList[[Row]:[Row]]=”1-1″),0)),””). The issue I have is I frequently need to adjust the size of a section (ex: making section “A1” 23 rows instead of 21 as shown). Currently when I add a row the new cells hold the formula from the top row, and pushes the old row 4 formula down to row 5. Is there a way to dynamically fil the formula to match its battleship grid location? Or at least keep the moved formula relevant to the row it gets moved to?

​I have one table which lists a trailer number, the section of the yard in which it is parked, and then the row inside the parking spot (TrailerList). I also have a table which will show visually where the trailer is parked based on this list (TrailerPark). I have it set to auto-populate the trailer name from TrailerList into the correct location in TrailerPark using the formula =IFERROR(INDEX(TrailerList[[Trailer]:[Trailer]],MATCH(1,(TrailerList[[Section]:[Section]]=”A1″)*(TrailerList[[Row]:[Row]]=”1-1″),0)),””). The issue I have is I frequently need to adjust the size of a section (ex: making section “A1” 23 rows instead of 21 as shown). Currently when I add a row the new cells hold the formula from the top row, and pushes the old row 4 formula down to row 5. Is there a way to dynamically fil the formula to match its battleship grid location? Or at least keep the moved formula relevant to the row it gets moved to?   Read More

​