How can I get the information from the diffrent table?

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

@Video_by_Pro

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

2 Likes