Article number
111
222
333
444
Table B:
The goods data
Want to play fast decision table whether all goods number in the table B in any location exists and that the entire line information feedback
CodePudding user response:
Using Vlookup lookup:B=VLOOKUP ($A2, table! $A: $Z, COLUMN (B1), 0)
Data description:
$A2 - said in A table to find the number of
B table! $A: $Z - in the data area to find in the table B
The COLUMN (B1) - line number, feedback data COLUMN
Note:
In the corresponding article number in the table B need in the first column, and cannot have repeating
Need feedback data back fill
CodePudding user response:
Learning, vlookup usage (find)