How Excel displays all the numbers of the warehouse where the number is located after entering a num

<> custom formula - press alt+11 - click insert - click module (2 columns query merge) function abc (a as range, b as range, c as string) as string

set ra =

if not ra is nothing thenfor i = 1 to

if , 1) = c and , 1) <"" then k = k & "," & 1)

if , 1) = c and , 1) <"" and instr(t, ,1)) = 0 then t = t & "," & 1)

if , 1) = "" then exit fornextif t = "" then

abc = ""

elseabc = right(t, len(t) -1) 'Deduplication.

abc2 = right(k, len(k) -1) 'Don't go heavy.

abc3 = split(abc1, ",", -1, 1)for j = 0 to ubound(abc3)m = ubound(split(abc2, abc3(j)))if m > n then

n = mabc, take the most repeated value = abc3(j)end if

nextend if

elseabc = ""

end if

end function

Is this the result you want.

f2=textjoin(",",true,if(vlookup($e2,$a$2:$b$9,2,0)=$b$2:$b$9,$a$2:$a$9,""))

Formulas should be formulated with the key combination Ctrl+Shift+Enter

This kind of information extraction can be done with vloolup.

It depends on the worksheet name, and the name needs to be referenced.

Yes, you need to create data in a table first, and specify a unique identifier at the same time, and use vlookup on other pages to achieve the effect, refer to the vlookup function for details.

If you enter the number and data in column AB of Sheet1 and the number in column A of Sheet2, then enter the following formula in cell B2 of Sheet2 and fill it down.

vlookup(a2,sheet1!a:b,2,0)

Please make a complete code and name, specification, model, etc. in a worksheet, and then use the vlookup function to look up the table where you need to fill in the form, and after entering the code, you can get the name, specification, model, etc.

Suppose you first create a complete code and name, specification, model, etc. corresponding table in Table 1, starting from A1 to D1000, now you need to enter the item field from Table 2 A1, A2 to enter the code, then please enter the formula in B2:

vlookup (A2, Table 1!.)$a$1:$d$1000,2,false)

Please enter the formula in C2:

vlookup (A2, Table 1!.)$a$1:$d$1000,3,false)

Please enter the formula in d2:

vlookup (A2, Table 1!.)$a$1:$d$1000,4,false)

If you need more than one row, copy the drop-down.

Simple, you have to do a ** will ** name specification model and other data first sorted out.

Then cite these sources.

The problem you are trying to solve is one of the simplest, most elementary problems for Excel learners. Try to reply as follows:

First set the table with code, name, specification, and model in Sheet1, now enter the code in Cell A2 in Sheet2, and then we enter vlookup($a 2,sheet1$a$2:$d$1000,2,false) in b2 and press enter, which will quote the name of another page; Then press and hold the B2 D-pad and pull it to the right, and the specifications and models will appear successively; Then the scroll down will display the name, specification, and model of other codes.

You take a look at the vlookup app in the attachment.

You need an information table, and you can use the vlookup function to find it based on the preset data in the information table.

Using function references, make two workbooks, one for all the product names and other information, and then use the hlookup function in the other workbook.

Best method, vlookup formula. The premise is that you must choose a table with the same purpose and reference it.

Use the vlookup function to understand its usefulness, and you will solve it yourself. I originally made an attachment for you, but I found that I can't upload an attachment in this "know" now.

Please create a data table first, and then use the vlookup function to help you get it and send it to me, and I will do it for you!

First of all, you need to have a table with numbers and names, and then use the vlookup function to take the names corresponding to the numbers in this table.

This problem requires a basic table, such as Table 1 as a basic table, in the format of employee number (column A), name (column B), etc.

The current table is Table 2, column A is the employee number, and column B is where the formula needs to be written.

if(isna(vlookup(a1, Table 2!.)a:h,2,false)),"The employee number does not exist", vlookup(A1, Table 2!a:h,2,false))

The subsequent content can be automatically displayed based on the fact that you want to have such a basic database. After that, it can be queried by either function or other means.

Use references and lookup functions,"vlookup"Function!