You can do this which is what i do for tables
if you need multiple tables you can code
=INDEX(indirect("TableName" & "_Body"),match(ValueB,indirect("TableName" & "_ValueB"),0),match(ValueA,indirect("TableName" & "_ValueA"),0))
(see sample sheet as to how I named It) using names like this gives it more clarity to find your errors as well!)
(note I only used ValueB as a sample rather than $c$1 in the match statement)
Bookmarks