There are a lot of ways to make a salary, but it is made by skill and has to be re-operated again next month. With the formula can be generated once and for all, is on the choice. With the search engine, get the first content is the case. Open a look, inside the formula is more complex, you can scare away a lot of beginners! In fact, this can be easily generated with VLOOKUP function, search engine misleading ah. Today, Luzu teaches you how to make money easily, single head and double watch. Copy the header to the new table and use the VLOOKUP function to generate it. = VLOOKUP ($ A2, single header! $ A: $ F, COLUMN (), 0) The role of the COLUMN function here is to get the second column, the third column ... the first column. A single head of the wages of the article to see detailed animation. Here you can choose 2 lines can also choose 3 lines down, if the choice of 2 lines, that is, no money line, the effect will be almost. In fact, with VLOOKUP function, regardless of a single header and double table, the operation is the same simple. Copy the header to the new table with the VLOOKUP function. = VLOOKUP ($ A3, double table! $ A: $ F, COLUMN (), 0) Double watch the wages of the article see the animation. Wage production is not very simple? Author: Lu child, Best-selling author, "Excel efficiency manual done early, no overtime" series series founder, personal public number: Excel does not work overtime (ID: Excelbujiaban)
Comments
Post a Comment