Small new flat board purchase and use experience

I have always wanted to buy a tablet to chase the vetera, occasionally write a note.Recently, I have to buy a netizen explosive struggle to spend more than 10 billion subsidies. Small pαd 11 inch is 862 yuan, and it is inevitable.

But all the e-products have been purchased in Jingdong, and there are very few a lot of water.But this time I rushed on this low price, I would like to turn over the seller’s various comments, and I found that comments can be.I want to try it.

The order was sent on the third day.Is SF!

The packaging is slightly thin.

Back display configuration

charger

Boot

Clear.Try to put a look of love

It is particularly clear, it is 2K, and the sound quality can also be.Try to install a few applications, very smooth!

Overall, I feel that it is not bad.It seems that I still haven’t turned it!After all, there is a hundred oceans, it is also more satisfied!

What is worth buying app all net shop shopping prices

Only 1439 yuan, full blood dragon 778g + 5000mAh + 120Hz screen, Vivo also has true incense machine

After the mobile phone market has been shuffled, it is already a game of giants. The share of major manufacturers is relatively stable. The market continues to force, and the online market has also launched a sub-brand to deal with, for example, there is no price-effective Vivo, IQOO has a strong good hand, from the entry to the high end, there are different gear products, such as the iQOO Z5, the author, the author saw it has 1439 yuan "true price", still worth it Purchase.

As an entry product, iQOO Z5 is very good, equipped with the Snapdragon 778G processor, supplemented by LPPDR5 + UFS3.1, and therefore called "full blood version", performance is more than other divo dragons 778G, Especially when the game and big file read / write speed, when installing the download app, there will be a certain advantage, using a 6.67-inch LCD screen, support 120Hz refresh rate, support DC dimming and Rhine TUV low blue-ray certification, show the effect in the overall size.

The battery life is also the selling point of the machine, built-in 5000mAh big battery, does not play games, one day can not be a problem, 44W flash charge can meet the needs of users, the back is 64 million + 8 million +2 million pixels Support 10x digital zoom, up to 4K video recording, although than many high-end flagships, but in the thousand-yuan machine, the Z-axis motor and stereo donkey blessing, also make it a good audio and video experience .

In terms of appearance, IQOO Z5 is a hidden opening screen, and the COF package has made it a lot of width in the chin, so it looks very coordinated, the back camera is a common rectangular module, but the three color matching have their own craft, "blue The origin of the origin is heavier, "Boli Chen" is not easy to contaminate the fingerprint, and "dream space" is more interested, similar to the design of the Roman column, so that the entire rear cover has three-dimensional, with a certain gradient treatment, The value is quite high.

Overall, the ethnographic performance on the market is good, and the major manufacturers have a model worth considering. It is like a red rice with Note10 Pro this all-round player, and there is a 120W fast charge like Note11 Pro +, OPPO home Realme There are also several real sauce machines, of course, comprehensive price, configuration, appearance, I still prefer iQOO Z5, third-party platforms, only 1400 yuan, more than 400 yuan than official channels, everyone thinks cost-effective, welcome to messages.

King of Find more than VLOOKUP, do you know for CP functions?

During our daily tabulation, it is often used.Find the work of reference related data.

In fact, this is also one of most small partners in touch.

For example, according to the corresponding results of the employee name, according to the number of item numbers in one item, the corresponding sales, etc.

Today, I will introduce you to a very powerful function combination to achieve this feature.

They are INDEX + MATCH combination.

The specific application scenario is as follows:

01 正 正 查

The correct point here is:Find reference target values ??from left to right.

That is, the lookup value is on the left and the return value is on the right.

As shown below, it is the performance watch of the company employee in the first quarter. We now want to find the corresponding performance according to the name.

Write the following formula in [F2] cell:

=INDEX (C2: C7, Match (E2, B2: B7, 0)))

Formula analysis:

First look up Liu Yan in the [B2: B7] in the [B2: B7], return to the number 2;

This number 2 is then used as the second parameter of the index function, meaning returning to the value of the first parameter in the cell area in the cell area in the cell region.

There are three parameters: Match functions:

Match (lookup value, find area, lookup type)

The MATCH function is specifically used to find a value, where you are in a region or group, and return a number.

This number that is usually returned as a parameter of other functions.

Here, the returned numbers are used as the parameter of INDEX.

If the lookup type of the third parameter is 0, it means an exact lookup.

INDEX usually has three parameters:

Index (Returned area, line number, list number)

Since the first parameter is a single line or a single column, the third parameter can be omitted.

If you don’t illegally, the formula can be written as this:

=INDEX (C2: C7, Match (E2, B2: B7, 0), 1)

02 reverse lookup

The reverse refer to it here is:Find reference target values ??from right to left.

That is, the lookup value is on the right, the return value is on the left.

Also as examples above, for example, we want to find Liu Yan’s employee number.

The formula is as follows:

=INDEX (A2: A7, MATCH (E2, B2: B7, 0)))

Formula analysis:

The formula of this formula is similar to the formula of the forward look, but the first parameter of the index function will change the returned area into the [A2: A7] area.

It can be seen that whether it is looking for a look, it is the same.

Just change the area of ??the first parameter of the index function into the area that needs to return.

03 two-way lookup

The two-way refers herein is:Find the reference target value from the horizontal and vertical two directions.

As shown below: It is a quarter employee payment message, and now I need to find how much Liu Yan’s salary in March is.

The formula is as follows:

=INDEX (B3: D8, Match (G3, A3: A8, 0), Match (H2, B2: D2, 0))

Formula analysis:

First look up Liu Yan in [A3: A8] in the vertical position in [A3: A8], return to the number 2;

Then use the second Match function to find the horizontal position in [B2: D2] in this area, return to the number 3;

Finally, the two numbers are respectively used as the second and third parameters of the INDEX function, meaning returning to the INDEX first parameter [B3: D8] zone "Chapter 3 of the third row in the area of ??this intersection cell, namely: 8606.

Because the two-way lookups here need to involve the position in both directions, we are hereUse two MATCH functions to locate the lines and columns.

04 more conditions

Multi-conditional lookup refers to: Find back to the corresponding target value based on 2 or more conditions, which is often used in our daily work.

As shown below: It is a sales list of all item numbers in all regions. We want to find how much the number of item numbers BH003 in Nanjing is.

Condition 1: Nanjing;

Conditions 2: The item number is BH003.

Write the following formula in the [G2] cell:

=INDEX (C2: C7, Match (E2 & F2, A2: A7 & B2: B7, 0))

Formula analysis:

The basic frame of the formula is the same as above, just first connect two conditions into a new condition form with a "&" text connection;

Then follow the ideas looking forward to the looks to the lookup and return to the sales volume in the [C2: C7] area.

Match function Find the location of "Nanjing BH003" in the newly generated array:

Match ("Nanjing BH003", 0)

Returns the number 3, then this number 3, as the second parameter of the index function, means returning the INDEX first parameter [C2: C7] The value in the cell in the cell area, that is, 72.

?

Because this is an array formula, the formula needs to be ended in the [Ctrl + Shift + Enter] three key. The braces outside the formula will be automatically generated. For small friends who use Office 365, you can end up with a three-key.

Of course, the multi-conditional lookups here can also be applied at both horizontal and vertical two directions.

In addition, no matter how many conditions, just connect multiple conditions to a new condition with a "&" text connector first, then apply the above routine.

05 interval lookup

The interval lookup refers to:If the lookup value is in a certain range, the corresponding target value is returned.

As shown below, the number of bonuses from the employee is required according to the performance interval.

Write the following formula in the [G2] cell:

=INDEX (J2: J5, Match (F2, {0; 41; 81; 121}, 1)))

Formula analysis:

This formula is especially the application of the second and third parameters of the MATCH function.

If the third parameter is 1 or omitted, the MATCH function will look for the maximum of less than or equal to the first parameter, andThe value in the second parameter must be sorted in ascending order.

The maximum value of less than 65 is 41, 41 in this constant array ({0; 41; 81; 121}) is 2, that is, the number 2 is returned to the number 2, and then the index second parameter is finally returned 2000.

Of course, here we can also write this constant number in an auxiliary column, which may be better understood.

As shown below:

06 blurry look

The fuzzy look is to realize the target value by combining with the wildcard ("?" Question mark and "*" asterisk).

As shown below: We want to find a surname Xu to open his head, and how much is the employee number of three characters.

The formula is as follows:

=Index (A2: A7, Match (E2 & "", B2: B7, 0))

Formula analysis:

Here is the key to the Match function supports the usage of wildcard.

Everyone must pay attention to:

"?" Question mark wildcard, represent any single character.

"*" Asterisk wildcard, represents any number of characters.

Here we used two "??" question marks, represent any two characters.

07 summary

Today, we have learned two powerful function combinations (INDEX + MATCH)Six kinds of findings commonly used in work:

? Positive lookup;

? Anti-(reverse) lookup;

? Two-way lookup;

Multi-conditional lookup;

Area lookup;

? Fuzzy lookup.

What is the most look for you usually use? What do you have any questions about VLOOKUP?

Welcome to usmessageOh ~