Excel input name to automatically pop up the price

The first thing to do is to make sure that the name is unique and that you can't get it wrong. The second can be used with vlookup, which is used as follows:

vlookup

Purpose: Find the specified value in the first column of ** or an array of values, and return the value at the specified column in the current row of ** or array. When the comparison value is in the first column of the data table, you can use the function vlookup instead of the function hlookup.

Syntax: vlookup(lookup value, table array, col index num, range lookup) Parameter: lookup value is the value that needs to be found in the first column of the data table, which can be a numeric value, a reference, or a text string.

A table array is a data table in which you need to find data, and you can use a reference to a region or region name. col index num is the column number of the matching value to be returned in the table array. When col index num is 1, the value in the first column of the table array is returned. col index num is 2, which returns the value in the second column of the table array, and so on.

Range lookup is a logical value that indicates whether the function vlookup returns an exact or approximate match. If true or omitted, an approximate match value is returned, that is, if an exact match value is not found, the maximum value less than the lookup value is returned; If range value is false, the function vlookup will return an exact match value. If it can't be found, an error value n a is returned.

Example: If a1=23, a2=45, a3=50, and a4=65, the formula =vlookup(50,a1:a4,1,true) returns 50.

You can take your time and you'll be able to do it!

You'll need to create a data table in advance. Enter the name, ** unit and other information. When re-entered, you can use formulas or VBA to write ** to achieve automatic jumping.

You need to have a basic table of ** and specifications corresponding to the name, and then use the vlookup function.

Establish a basic profile.

Then use vlookup referencing and you're good to go!

In Sheet1, column A sets the basic information such as the model, column B: **, sheet2, A1-A1000 enter the model, and B2 input: =vlookup(A2, sheet1!

a:b,2,0) enter, copy to b3b1000 set a1 as the name, b1 as the unit price, c1 as the quantity, d1 as the amount b1 cell input: =if(a1="Poplar 5*10*400",30,)d1cell input:

b1*c1。

1. There are many business management software such as Kemai to establish a template.

2. The formula is: =lookup(a1,,) Explanation: when a1=1 then b1=1000, a1=2 then b1=2000.

3. You can give the product number first. The excel lookup function cannot be in Chinese, so you number first.

4. That's it, when you input A1 cell: poplar 5*10*400, B1 will automatically become 30, and when C1 cell input quantity, D1 will automatically calculate**.

It is not possible to only enter the name and model to jump out of the unit price, because many of your models and names are the same, but the procedures are different, so you have to combine the name, model and procedures to jump out of the one-to-one correspondence**:

The formula of column I unit can meet your requirements.

Summary. Dear, I'm glad to answer for you, what you said is automatically given according to the name**, which can be achieved with the vlookup function, provided that there is a corresponding table with a name and ** is also given in excel in advance.

Can you enter the product name in excel and it will be automatically given**.

Dear, I'm glad to answer for you, what you said is automatically given according to the name**, which can be achieved with the vlookup function, provided that there is a corresponding table with a name and ** is also given in excel in advance.

vlookup(c4,$g:$h,2,0)