Excel-related simple operations-Vlookup operations

Vlookup Background: During Bi development, you may encounter a very large table with hundreds of database fields. During field mapping, the actual field order may not be so arranged (for example, the mapping order in table ), manual identification of the length of several hundred fields (in fact, the Order in Bi development tools may be the order in table C) is very painful and prone to errors, vlookup is useful.

Preparations:
Extract the value before the Excel braces = left (B2, find ("(", B2)-1)

Extract the value = trim (right (substitute (B2, "(", rept ("", 10), ")", rept ("", 10), 20) Get the length in Table

From table A to table B, there is a value copy action

Use the unit input of B18 in Vlookup Table C = Vlookup (A18, $ J $2: $ K $, 2, 0), press enter, and double-click the cell, the application length between B18 and b25 is calculated.

Others:

$ Is fixed
= A $1 * B1 fixed A1
$ A $1, $ is an absolute reference.
Description: http://blog.csdn.net/qq1987924/article/details/7927829

 

(End)

Excel-related simple operations-Vlookup operations