How to ignore inputs when looking for data in a table

Hi all, I would like some help trying to code in Excel without using VBA if at all possible.    Data Product and Next Product Table           Data Table       Product Max SA Tank o...