In EXCEL, how to automatically fill in related categories in other tables after selecting an option in a drop-down list?

Assume that in the sheet 1 table, A 1 to A 100 are all product names, and b1:b100 is the corresponding price of all products.

I want to create a drop-down option in A 1 of sheet2 table to select a product, and the price of the product will be automatically generated in B 1.

Please do this:

1, select a1:a100 of sheet 1, and enter a name, such as "product list" (that is, a1:a/kloc-0) in the name box in front of the formula editing bar.

2. Select A 1 cell of sheet2, and menu: Data-Validity. In the pop-up dialog box, where the validity condition is allowed, select Serial.

In the Source box below, enter = product list (that is, the name you just set).

OK, so that the drop-down option for selecting products is established;

3. B 1 cell input formula of sheet2

=vlookup(A 1,sheet 1! A:B,2,)