Guys, I am using VLOOKUP function like this:

=VLOOKUP($B2,Produtos!$B$1:$Q,16,FALSE)

When I click on REGENERATE STRUCTURE button, the Spreadsheet formula is:

VLOOKUP(RC2,Produtos!R1C2:RC17,16,FALSE)

But, when I insert a new register on Google Sheet Table, the formula of the new regisrter column has been changed to:

=VLOOKUP($B3,Produtos!$B$1:$Q3,16,FALSE)

So, the formula is putting the number of line ($Q3) instead of ($Q) only, and the data is not founded.

Someone could help me?