How can I get the information from the diffrent table?

1

I am using two tables and I want to display the information of the first table on other on the basis of input. Please find the screenshot below

EcoMIGHT
EcoMIGHT830×678 41.6 KB

2

@Video_by_Pro

In the Sold column, try this formula:
=Type.Gallons * Qty

2 Likes