Current location - Trademark Inquiry Complete Network - Trademark inquiry - In excel, how to enter the commodity number in column A, and the corresponding commodity name will automatically jump out in column B?
In excel, how to enter the commodity number in column A, and the corresponding commodity name will automatically jump out in column B?
1. First, set a table of commodity numbers and commodity names on the right side of the table, for example, I set it in the H: I column.

2. If you need to display different commodity names in cell B2 according to the number of cell A2, you need to enter the formula =VLOOKUP(A2, H:I, 2, FALSE) in cell B2, which means that when cell B2 matches the value of column H according to the value of A2, the content of column I will be displayed; FALSE is an exact match.

3. If you want to copy it, just drop it down directly, or you can copy and paste it directly into other needed cells.

4. Then create a commodity number and commodity name table in Sheet2.

5. If you want the data in cell B2 to display different product names according to the number of cell A2, you need to enter the formula =VLOOKUP(A2, Sheet2! A: B, 2, false).