Home / Gadget Insights

Enter the name of the table to automatically skip the unit price

time:2024-10-22 15:03:27 Gadget Insights

。 How to enter the name in the table and the unit price will automatically pop up

1. Open the Excel sheet on the computer, and enter the model, name and unit price in Worksheet 2.

 2. Schedule 1 with a table.

3. Enter the formula =VLOOKUP(A2,Sheet2!) under the name in Sheet 1. A:C,2,0)。

 4. After entering the formula, press enter and scroll down to copy the formula.

《Enter the name of the table to automatically skip the unit price》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Ranking

Digital Insights