I guess what you want to do is make 3 names for each table
MyTable
table
TableValueA
=offset(mytable,0,0,1,columns(Mytable))
TableValueB
=offset(MyTable,0,0,rows(Mytable),1)
then you can do
Index(Mytable,match(ValueB,TablevalueB,0),match(valueA,tablevalueA,0))
If your table changes just change MyTable to reference the new table limits!
Bookmarks