In excel, you can query the sales record table according to the number by setting the formula of each column cell.

1. Enter the product code and the product information will be returned automatically.

2. Set the formula of each column of cells.

3. Enter the product number in the sales record table.