Hot to create a summary table by pulling data from two other tables using common ranges

Good day:  First, please note that I am blind, so need clear text based instructions.  I have a workbook containing three sheets.  One sheet has data in three columns, with columns a,b and c containing a list of unique product names, price and vender name respectively,  Sheet 2 contains a set of three columns, with column 1 containing entries for products by name, column 2 containing entries for whether the products were bought using cash/debic/credit, and the third column containing a numeric value for the number of that product sold in the transaction.  Sheet 3 is a summary sheet, where I want to create a list of products that appear in shehet 2 that are sold by a specific vender from sheet 1, then calculate the total price based on the number of items sold from sheet 2 for each item listed tiems the price from sheet1.  I can find filters and vlookups that will pull a vender and price from Sheet 1 if I know a product to search for, or the payment type and number of items sold from sheet 2 if I know a product name, but can't seem to find a function/formula that will do both and produce the desired output.  The rows in sheet 2 can change depending on data supplied, so I want to dynamically build the rows in sheet 3 as data is provided in sheet 2.  examples of data  Sheet 1 has three columns, with row 1 being bolts,$.10,company a.  row2: nuts,$.05,company a.  row 3: screws,$0.25,company b.  Sheet 2:  row 1 = bolts,credit,50  row 2 nuts,debit,50 row 3 screws,cash,100.  sheet 3 would have a summary table that might find all products sold from company a, so would list in row 1 bolts,credit,$5.00 ((50@$.1 each) row 2 would have nuts,debit,$2.50 (50@.05 each).  Since Company A does not sell screws, it would not appear.  I am new to Excel 2024 (desktop version).  Is there an easy way to do this withouthaving to resort to creating intermediate tables?