New safety technology of Xingheng lithium battery improves the safety standard of battery use.

In recent years, the wide application of lithium batteries has brought convenience and innovation to our lives. However, the safety of lithium batteries has also attracted widespread attention. Therefore, Xingheng Lithium Battery Company is committed to researching and developing new safety technologies to improve the safety and reliability of lithium batteries.

 

 

As a manufacturer of lithium batteries for head electric vehicles in China, Xingheng Power has always regarded the safety of lithium batteries as the top priority. The original "Six Safety Systems" of Xingheng started from various aspects, including six safety systems, including material safety, battery safety, BMS safety, PACK design, special safety charger and safety standard certification, in order to solve the possible safety hazards of lithium batteries, such as overheating, short circuit and overcharge and discharge. Provide the ultimate safety protection for lithium battery users. While ensuring the safety of products, we will promote the development of lithium battery industry by providing high-quality lithium batteries to the market.

 

 

Xingheng lithium battery has advanced production equipment and technological innovation ability, and is committed to providing high-quality lithium battery products for various industries around the world. In the process of lithium battery production, Xingheng has started the "life cycle quality management" process, and established a perfect enterprise safety and quality awareness, which includes the complete management of supply chain, whether it is product design or production line process quality management. It can be said that the whole system from research and development to production covers the quality and safety inspection of each process. It can be said that the products of Xingheng lithium battery have very strict safety control throughout their life cycle.

 

It is precisely because of this that the reputation of Xingheng lithium battery in the market has always been excellent, and the most advanced battery management system has been adopted to ensure the effective protection of battery overcharge, overdischarge and short circuit, so it has been unanimously recognized by users. The product quality and safety of Xingheng lithium battery has achieved zero major accidents in 20 years, which is the most convincing safety endorsement of lithium battery industry. In addition to focusing on product quality and technological innovation, Xingheng lithium battery also attaches great importance to environmental protection and sustainable development. The company actively promotes low-carbon, energy-saving and environmentally-friendly production methods and is committed to reducing the harm to the environment.

 

 

Xingheng Lithium Battery has been committed to promoting the energy revolution and providing sustainable energy solutions for the society by developing more efficient and environmentally friendly lithium battery technology. The whole team pays attention to the concept of innovation and sustainable development in the research and development process, and constantly seeks breakthroughs to improve the performance and life of lithium batteries and reduce the impact on the environment. The safety problem is the foundation that the whole enterprise of Xingheng Power Supply has been adhering to, which is also the core advantage of the product.

 

 

Experts advise not to swim for more than two hours

    Experts remind that alcohol can inhibit the normal function of the liver, hinder the transformation and storage of glucose in the body, and lead to accidents.


    The weather is hot, and swimming is people’s favorite summer exercise. Recently, the reporter learned from major hospitals in the city that since the summer, the sporadic cases of pink eye have increased significantly, which has a lot to do with improper swimming protection in public swimming pools. In addition, sprains of waist and neck joints caused by insufficient warm-up before swimming also occur frequently. Experts remind that some people like to drink a little wine before entering the water, or drink beer during swimming breaks. As everyone knows, alcohol will hinder the transformation and storage of glucose in the body, leading to hypoglycemia symptoms such as palpitation, fatigue, nausea and sweating.


    Swimming for more than 2 hours is prone to chills and spasms.


    Some swimmers soak in the water for half a day, and when they get goose bumps and start to chill, they realize that they have gone too far. Liang Weiguo said that the skin generally has three reaction periods to cold stimuli. The first stage is after entering the water, stimulated by cold, the skin blood vessels contract and the skin color is pale. In the second stage, after staying in the water for a certain period of time, the blood circulation is accelerated, the heat is increased, and the skin turns from pale to light red. In the third stage, the body stays in the water for too long, and the heat generated by the body is lower than the heat dissipated in the water, so that the body temperature regulation function is destroyed, and arterial contraction and venule expansion will occur, resulting in blue skin and black lips, "goose bumps" and even spasms. This is a taboo period for summer outing, so you should leave the water in time. Generally speaking, the swimming duration should not exceed 1.5 ~ 2 hours. If you feel unwell, you should immediately go ashore to dry the water and bask in the sun, and get dressed as soon as possible after your body is warm to prevent colds, tachycardia, muscle strain and other diseases.


    Swimming before and after meals will affect digestion.


    Swimming while drinking beer? This idea sounds pleasant, but in fact it is not healthy at all. Liang Weiguo pointed out that after drinking and swimming, a large amount of glucose stored in the body is consumed, and hypoglycemia will occur. Alcohol can inhibit the normal physiological function of the liver and hinder the transformation and storage of glucose in the body, leading to accidents. At the same time, alcohol will affect the brain’s judgment ability and increase the chance of danger. Therefore, it is best not to drink alcohol when swimming. In addition, swimming consumes a lot of energy, and it is easy to feel hungry. Some people can’t wait to have a big meal as soon as they land. Experts pointed out that it is advisable to rest for half an hour before eating after swimming, otherwise it will suddenly increase the burden on the gastrointestinal tract and easily cause gastrointestinal diseases for a long time. Liang Weiguo reminded that swimming is actually avoided before and after meals. Swimming on an empty stomach will affect appetite and digestive function, and accidents such as dizziness and fatigue will occur during swimming. Swimming on a full stomach will also affect digestive function, and it will also cause stomach cramps and even vomiting and abdominal pain.


Editor: Zhao Xuanxuan

What is the contest from The Birth of an Actor to Fashion Week?

China stars who fought in 2018 Fashion Week in The Birth of Actors.

Special feature of 1905 film network Last week, with the gorgeous end of Paris Fashion Week, 2018 Fall/Winter Fashion Week officially came to an end.

There are many fresh faces of China stars in this fashion week, and they are busy watching shows and catwalks. However, in this list of nearly 60 people, it is surprising to find that some stars have a long history. They are all acting café s or topic figures who came out of the stage of The Birth of an Actor, but this time they moved to the fashion field and continued to "compete for beauty".


"My Father and Mother" Daddy loves leather pants — — Allen


Allen in Glory of the Tang Dynasty


In 2017, Ren Jialun quickly became popular with her wonderful performance in "Glory of Datang" and became a hot and popular niche. In The Birth of the Actor, he challenged himself as the first group of contestants in the first issue. In the autumn and winter fashion week of 2018, I also completed my fashion debut.

letLun Jia performed My Father and Mother.


Allen performed the classic "My Father and Mother" by his mentor Zhang Ziyi in "The Birth of an Actor", and his performance was calm and affectionate, which was moving. The subsequent improvisation also showed super responsiveness. Although he lost in the end, his professional attitude was impressive.

Upgrade to be a dad.


Just before the New York Fashion Week, on February 2nd, Ren Jialun announced through Weibo that she had been upgraded to be a daddy. Perhaps it is the change of identity that makes Allen more confident and calm. Although she is attending Fashion Week for the first time, she is full of aura.

Depart for New York Fashion Week


Depart for Coach 2018Autumn and winter seriesbeautiful


On February 13th, Ren Jialun, a close friend of Coach brand, wore a purple baseball uniform jacket with a small white T and cool black leather pants, and set off for new york to help the Coach 2018 autumn and winter series show.

Daddy loves leather pants.

Allen is wearing a camouflage jacket.

February 13th, the same, is new york with a difference of 12 time zones. Allen wore a camouflage jacket with a purple sweater under it, and leather pants remained the same, making her debut at the Coach show.

On the big show, although Ren Jialun and beautiful young ladies and sisters from all over the world have intimate photos, no one dares to think anything about your dad with this "abstinence straight man" face.


War and beauty in Fashion Week — — Shu Chang VS Xin Zhilei


Shu Chang Xin Zhilei

Shu Chang and Xin Zhilei, two acting artists, gained a lot of recognition and applause in The Birth of an Actor. War and beauty, which was performed by two people in the second stage, and Painted Skin, which was co-produced in the follow-up, are works with strong plot reversal and tension-free. In the performance, the two people also hurt each other and made great performances, showing their love and hate to the extreme. Without special effects in the later stage, we can see the effect of small knives flying all over the screen from their performances.

The grovelling, happy and jealous Xin Zhilei in war and beauty.


Shu Chang appeared as a servile maid "An Qian" in war and beauty, and was tortured by Xin Zhilei’s jealous "Xin Guiren".

In The Birth of an Actor, Xin Zhilei, the "Opponent"&Shu Chang.

When "Anqian" turned her face faster than turning pages, it showed the pride of being favored and sealed and the smoothness after revenge; "Xin Guiren" also experienced the process from disappointment to despair emotionally and spiritually.

Xin Zhilei’s "Painted Skin" is decorated with Pei Rong’s version of Xiaowei.


This conflict of role relationship and the change of characters’ emotions are also reflected in the Painted Skin.

Shu Chang Edition of The Painted Skin in The Birth of an Actor

The familiar story moved from the screen to the stage, and there was no film special effect or scene change. It was only through deductive expression of the change of role exchange. It can be seen that the superb acting skills of the two men and the wonderful confrontation were full of flames, and these two firepower also burned from the stage of The Birth of the Actor to Fashion Week.


Shu Chang appeared at the Tadashi Shoji autumn and winter 2018 conference.


Comfortable and elegant

On February 8, Shu Chang took the lead in setting off for New York Fashion Week and appeared at the Tadashi Shoji Fall/Winter 2018 conference. A white turtleneck sweater in a white lace suit with a black background, refreshing short hair and exquisite makeup make the petite and comfortable figure less vicious and more sweet and lovely.

Xin Zhilei appeared at the airport to go to Paris Fashion Week.


Xin Zhilei was also invited to attend the Yves Saint Laurent Fall/Winter 2018 show.

The red chain bag is eye-catching

Wearing a black baseball jacket with striped sleeves in SPRING 2018, a leather chain bag with red stitching on the back, and black slim trousers with leather booties of the same color, it is simple and does not lose its aura, leaving for a fashion appointment.

Xin Zhilei YSL show rebellious queen Fan Er

On February 27th, Paris time, a cool black LOOK appeared in the big show. Without the ingenuity and despair of "Xin Guiren", the charm of "Pei Rong" and "Xiao Wei" could not be found, and some were a little rebellious and domineering queen.

Different queen gas fields


Shu Chang and Xin Zhilei are like two blooming roses, which are fragrant all the way from the stage to Fashion Week.


The upstart fashion on the stage of Nortel’s freshman show — — Karry


9b884b3bly1fohl6ni5rkj21sg2dskjl.jpg

Karry

In 2017, Karry was admitted to the Beijing Film Academy with a score of 99 points exceeding the admission score of Chongqing art candidates.After school started in September, my little brother, who was addicted to learning, seldom showed up. However, a news that he was going to participate in The Birth of an Actor attracted widespread attention. As a top traffic idol, it is an accident to dare to board the stage of "The Birth of an Actor".


Karry, the co-star of The Birth of an Actor.

On the stage of The Birth of an Actor, Karry was still a humble and courteous student, but he changed his attitude when he walked on the show floor, and turned himself into a little oriental prince who swam in the fashion kingdom.

Dolce&Gabbana;The first Asia-Pacific brand ambassador

As the first brand ambassador of Dolce&Gabbana in Asia-Pacific, Karry attended Milan Fashion Week for the second time. Although this is just a show, Karry’s fashion trends have attracted a lot of attention since she made her debut at the Dolce&Gabbana show in June last year and participated in the closing show with the highest specifications of domestic male artists.


Karry leaves for Milan Fashion Week.

      In the early morning of February 24th, Beijing time, Karry, who appeared in the airport wearing a full set of LOOK of Dolce & Gabbana Spring/Summer 2018 collection, started his second fashion trip. He wore it simply and casually, and his increasingly angular three-dimensional facial features can still find the appearance of a teenager.


Karry meets Milan in early spring.


On the same day, Milan time, at the Dolce & Gabbana 2018 Secrets Diamonds autumn and winter high-end women’s dress series show, Karry made a stunning appearance in the spring and summer 2018 men’s sequined embroidered suit and evening dress with Sicily series and Pietre series high-end jewelry accessories. It is suspected that few people can not wear this collar-designed evening dress as a waiter’s uniform, but Karry successfully "suppressed" it with his sense of youth and extravagance.

Oriental Beauty Juvenile Karry

The whole big show has its own lighting effect of bilingbiling, but it can’t hide Karry’s own brilliance. There is no need to add a crown, and the momentum of the king is also released in all directions.

Karry appeared.Dolce&Gabbana 2018/19 Fall/Winter Women’s Wear Show


On February 25th, however, Karry became a little prince who strayed into the "girl country" at the Dolce & Gabbana Fall/Winter 2018/19 Women’s Wear Show.

Karry Junyi gentleman

Wearing a burgundy embroidered suit for men’s wear in the spring and summer of 2018 with Pietre series of high-grade jewelry accessories and Ispica series of butterfly embroidered velvet loafers, Karry, who was in the first row to watch the show as a handsome gentleman, was surrounded by a group of beautiful ladies and sisters and could only return with an embarrassed and polite smile.

Karry is in the "daughter country"


Karry, the little prince in a suit and tie on the show, also had the supporting experience of playing the Crown Prince in The Birth of an Actor. He played against his mentor Zhang Ziyi in "Abandoned Princess in the Harem". Although his performance is still a little green, he has made great progress compared with the shaping of small and medium-sized emperors. What remains unchanged is Karry’s own king temperament.

"Abandoned Princess in the Harem" plays the Crown Prince.


Although he was only a guest performer, Karry won the love of his tutor Zhang Ziyi and the recognition of the audience with his excellent performance and a humble self-introduction of "I am Karry, a freshman of Nortel University". He himself said that he took the mid-term exam in advance with a learning attitude. The impromptu sketches of Zhang Ziyi and Liu Ye on the spot also show Karry’s smart and funny side, and let more people see the infinite possibilities in him.


From the dance of flying daggers to the Paris show — — Gina Jin


Gina Edition "House of Flying Daggers" Modeling


On the stage of The Birth of an Actor, Gina also reproduced the classic work "House of Flying Daggers" by his mentor Zhang Ziyi, and also showed off the classic "Water Sleeve Dance" in the movie. Even Zhang Ziyi himself praised it after watching it: It’s not easy to shoot the pictures presented in the film for many times at a time on the stage.

Jin Chen competed in The Birth of an Actor.

The wonderful performance of "Little Sister" not only enabled Gina to be promoted successfully, but also performed the quaint "Princess De Ling" and the elegant manners displayed on the stage, which also made her gain more attention from the fashion circle. Gina attended three big shows at the Paris Fall/Winter Fashion Week in 2018.

Carven big show scene Gina

On March 1st, Paris time, Gina took the lead in appearing in the Carven show with an indigo and dark green short-sleeved shirt and a milky white high-waisted skirt. It is worth noting that Gina’s upper body with floral neckline and ruffled neckline not only failed to hide the beauty, but also highlighted Gina’s elegant and slender neck lines.


Gina attended the Issey Miyake show.


Show retro elegance

On March 2nd, Jin Chen was invited to attend the 2018 autumn and winter show of Issey Miyake in Issey Miyake. Wearing a blue and green striped dress, diamond earrings with green tassels and a black retro belt at the waist, Gina’s perfect figure is outlined. I changed the shape of the meatball head the day before, and chose to bundle my hair at will, which is elegant and mature.

Gina Vivienne Westwood watches the show.


Modeling girls is full of sense.

The last stop of Paris Fashion Week in Gina went to Vivienne Westwood’s autumn and winter 2018 show. On March 3rd, Gina wore a short-sleeved white T, a tube-top printed skirt and pink high heels, and wore a playful double braid, which made her feel youthful and girly.


Gina went to Paris to meet him.Lian attended three big shows.

Three sets of different shapes highlight Gina’s plasticity and show her diverse expressive force in performing arts and fashion.


"Carry Love to the End" — — Sophie


Sophie

As high flyers in Chinese opera, Sophie, who was born as a child star, appeared on the stage of The Birth of an Actor and was also a popular seed player with her own topic. Her performance full of spirituality, vitality and appeal was highly anticipated at the beginning of the competition.

"Carry Love to the End" Sweet "Little Wen Hui"

In the program, Sophie’s "Carry Love to the End" vividly interprets a girl in love, and is recognized as "not acting, but really falling in love". Sophie, who is full of girlish feelings, also brought this youthful atmosphere to the show of 2018 new york and Milan Fashion Week.

Sophie departs for New York Fashion Week.


Sophie, who started New York Fashion Week on February 10th, performed two sets of different styles at the airport before departure. The black coat with ripped jeans, striped shirt and sweater is simple to wear, which makes Sophie look a little mature.

"Chao" flavor girl

Another wash jeans suit with a red baseball cap is youthful and cool. Both sets of LOOK are beautiful, and Miss Jie is also switching between maturity and youth at will.


Sweet and fresh style to attend Ralph Lauren 2018 spring show

On February 13th, new york time, Sophie took the lead in appearing in Ralph Lauren Spring 2018 series show with a fresh look. Matcha knitted vest with a light orange shirt and handsome suspenders was full of vitality.

The meatball head shape attended the Michael Kors show.

On February 14th, Miss Wang was also tossing and turning with two big shows. At the Michael Kors 2018 autumn and winter series conference, the mature miss appeared again, with a meatball head shape, camel double-breasted casual suit jacket and wide-leg pants of the same color, which was refreshing and capable without losing the mature atmosphere.

Marc Jacobs turned into "mermaid princess"

Sophie, who moved to the autumn/winter show of Marc Jacobs 2018, switched back to the quirky little fairy, wearing a retro yellow turtleneck with sequined green wide-leg pants, which looks like a "mermaid princess".


Three sets of LOOK in new York fashion week

After finishing his trip to Milan, Sophie moved to the show of Milan Fashion Week to continue harvesting.

The first stop of Milan Tour-Hogan Show

Sophie, who appeared in the Hogan show on February 22nd, continued her refreshing and capable dressing style. She wore a shirt with a big neckline, a warm orange sweater and jeans with a thick rope belt, which was fresh and sweet without losing her personality.

Sophie Furla show is booming.

In the second stop, I went to Furla show with a full set of red LOOK, with a classic plaid shirt in a big red coat and red suit pants. Sophie looked really prosperous.

Small waist essence Sophie big show big long legs

On February 23rd, Sophie’s vitality appeared in the SportMax2018 Fall/Winter 2018 show. The wearing of a light blue shirt with high waist and brown leather shorts fully demonstrated her perfect figure and long legs.

BVLGARI show elegant welcome online.

On February 24th, a retro and elegant black dress, which greatly changed the previous style, appeared in the BVLGARI show, and the young lady with mature temperament was also charming.

Sophie "Flower Fairy" Modeling

On February 25th, he was invited to attend the show in the first row of MARNI. Sophie, wearing a pink printed waist-shrinking top and fluffy skirt, went online sweetly, and seemed to see the flower fairy in a trance.


Milan Fashion Week big-name harvester Sophie

Although Sophie performed a number of different styles of clothes in Fashion Week, the age of a teenage girl can’t hide the youthful breath that will overflow the screen, just like "Little Wen Hui" in "Carry Love to the End".


The gorgeous transformation from actor to fashion darling

These actors, she/they have performed intriguing works on the stage of The Birth of an Actor, and also showed their unique style in the fashion field in addition to their actress status on the show of 2018 Fashion Week, whether they are competing opponents or new peanuts.


High morale and charm! Zhanjiang middle school students’ women’s football team went to Leizhou to select outstanding athletes.

In order to prepare for the provincial finals of the "Governor’s Cup" Youth Campus Football League (senior high school group) in Guangdong Province in 2023 and the women’s football match related to the 14th Middle School Games in Guangdong Province in 2025, on March 8th, Zhanjiang Education Bureau entrusted the coaching staff of Zhanjiang Aizhou Senior High School to select outstanding women football players from Yangjia Middle School in Leizhou City.

The women’s football team of Zhanjiang Aizhou Senior High School is the women’s football team of Zhanjiang Middle School. In the afternoon, the coaching staff of Zhanjiang Aizhou Senior High School came to Yangjia Middle School Stadium to carry out the selection activities. This selection activity is carried out by means of basic selection and actual combat selection. The basic selection mainly includes 30-meter running and standing long jump to test the players’ physical fitness and explosive power. In the actual combat stage, the players’ passing and catching ability, offensive and defensive awareness, technical and tactical application in the game are comprehensively investigated. Under the guidance of the coach, the players are selected and assessed in turn.

In the trial match between Zhanjiang Aizhou Senior High School Football Team and Yangjia Middle School Football Team, the athletes from both sides put themselves into the game in the best competitive state, fought for the initiative, showed the unity and tacit understanding of the team to the fullest, and showed the charm and passion of football with high fighting spirit. Through the competition, a group of outstanding female football players will be selected, and a group of outstanding talents will be delivered to the Zhanjiang middle school students’ women’s football team to prepare for the 14th Guangdong Middle School Games in 2025. In order to enliven the atmosphere and show the talents of the players, there are also football dances and singing programs interspersed with football elements and technical movements, so that students can feel football, know football and love football in the dance.

It is reported that in recent years, Yangjia Middle School in Leizhou City has devoted itself to building a national youth campus football characteristic school by educating people, cultivating morality and keeping fit. Under the personal promotion, participation and guidance of the principal of the school, in 2022, the school’s football team participated in the "Mayor’s Cup" football competition in Zhanjiang, and both men’s and women’s teams advanced into the top 8, among which the men’s football team won the third place and the women’s football team won the sixth place.

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 ~