help with making formula refer to dynamic table

this is what I have:

=VLOOKUP($J$2,maint!$I2:$AT17,MATCH(Q1,table17[[#Headers],[To: owner/rep]:[condoFee?]],0),0)

and the "$I2:$AT17" part is the table I'm referring to, which happens to be "table17" also referenced in this formula.

Problem is, I add rows to this table, after which any row residing below row 17 produces an error, obviously.

So I thought to replacing "$I2:$AT17" with "table17" but that didn't help. Should it have? What should I do? Thanks.

thanks. here, I've simplified it plus the original file has a lot of people's info on it.

https://www.dropbox.com/s/pznh825a7e...ook1.xlsx?dl=0

should be self explanatory. sheet 2 is referencing sheet 1 with vlookup and using match to match the column right. anyway, so it's shorter and I used your suggestion with the "#all" but I'm still getting an error. Hopefully this helps you help me. Thanks!

oh wait a sec, I've forgotten how vlookup works. reset. so you can't reference a table with vlookup unless the first column is the one where you're reference is located correct?

With a Vlookup (from Excel help)

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Looks in the first column of an array and moves across the row to return the value of a cell

Tip: The secret to VLOOKUP is to organize your data so that the value you look up (part number) is to the left of the return value you want to find (price of the part).

Maybe you want to look at Index/Match

thanks. As it happens so often I resolve my problem accidentally on my own. IDK what happened but it just looks to me like Excel was being temperamental, but playing around with here and there somehow it started returning the right values.