Focusing on World Peace and Stable Development and Contributing to China’s Smart China Program (100 foreign political party politicians see the CCP)

  Figure 1: Aken Suwell, Chairman of Marmara Strategic and Social Research Foundation in Turkey.

Figure ②: Wu Wending, editor-in-chief of North Star magazine in Myanmar.

Fig. 3: awad, deputy editor-in-chief and expert on international issues.

Figure ④: Bubacar Seyni Gagaha, Deputy Secretary of Propaganda of the Socialist Party of Niger.

Information picture

  Montenegro North-South Expressway Project undertaken by China enterprises. image china

  From reform and opening up to overall poverty alleviation, from building the Community of Shared Future for Mankind concept to building a "the belt and road initiative", under the strong leadership of the Communist Party of China (CPC), China not only strode forward on the journey of realizing the great rejuvenation of the Chinese nation, but also continuously contributed China wisdom and China plan to world peace, stability and development, which won universal recognition from international people.

  Wu Wending, editor-in-chief of North Star magazine in Myanmar — —

  Based on the long-term, promote the continuous development of China.

  Our reporter Li Bingxin Zhou Zhuobin

  "I have been to many places in China, and I personally realized that the Communist Party of China (CPC) kept in mind the iron oath. I saw with my own eyes that the Communist Party of China (CPC) would not let a minority brother fall behind and always let the people of the whole country get rid of poverty and get rich together." Wu Wending, editor-in-chief of North Star magazine in Myanmar, has been paying close attention to the development of China. He said, "The deeper you know about China, the more you admire the Communist Party of China (CPC). I deeply feel that we and the people of China are a community of destiny. "

  Wu Wending knows a lot about China’s development achievements. He has been paying close attention to the Communist Party of China (CPC) news for a long time and kept close communication with his counterparts in China media. In recent years, he has reported on the high-level dialogue between the Communist Party of China (CPC) and the world’s political parties, and has come to China for many times to participate in the "the belt and road initiative" media cooperation forum and the Lancang River — Media exchange activities such as Mekong River Cooperation Media Summit. In 2017, at the invitation of the International Liaison Department of the CPC Central Committee and People’s Daily, Wu Wending participated in the "Asian Mainstream Media Investigation Group" and went to Beijing and Gansu for interviews and exchanges. What I saw and heard in China gave Wu Wending a deep understanding of the Communist Party of China (CPC)’s ruling philosophy. In Wu Wending’s view, it is under the strong leadership of the Communist Party of China (CPC) that great changes have taken place in China from poverty and weakness in the past to prosperity and strength now.

  During the 19th National Congress of the Communist Party of China, Wu Wending came to China and made a lot of reports on many topics, such as ecological environment protection, grassroots pension, coordinated development of Beijing-Tianjin-Hebei, and media integration development. After visiting the large-scale achievement exhibition of "Five Years of Hard Work", Wu Wending expressed sincere admiration for the brilliant achievements made by the Communist Party of China (CPC) in leading the people of China, and wrote a poem entitled "Red Star Shining in China" to express his admiration for the Communist Party of China (CPC). “‘ The Communist Party of China (CPC) comes from the people, lives for the people and prospers for the people ’ ‘ The Communist Party of China (CPC) is a party that strives for happiness for the people of China, and it is also a party that strives for the cause of human progress ’ I think that the Communist Party of China (CPC)’s feelings for the people are well reflected in these words. " He said.

  “中国共产党不仅把为人民谋幸福作为自己的头等大事,还积极倡导世界和平与发展。”吴温丁表示,新冠肺炎疫情防控期间,人们愈发意识到,人类社会是休戚与共的命运共同体,重大传染性疾病防控和全球公共卫生应急管理需要凝聚全人类的智慧和力量。“习近平主席提出的构建人类命运共同体理念具有重大世界意义。共建‘一带一路’是中国与沿线国家和地区分享发展机遇的实践,是构建人类命运共同体的重要举措,让世界人民看到了改善生活的希望。”吴温丁表示,“有些国家的政客只考虑下一次选举,而有远见卓识的政治家考虑的是下一代人。中国共产党的领导集体由有远见卓识的政治家组成,总是为下一代人考虑,做长远打算,推动中国不断向前发展。”

  Aken Suwell, Chairman of Marmara Strategic and Social Research Foundation in Turkey — —

  Benign interaction makes China society full of vitality.

  Our reporter Wang Chuanbao

  "The secret of China’s rapid growth into the world’s second largest economy lies in the Communist Party of China (CPC)’s strong leadership." Aken Suwell, Chairman of the Turkish Marmara Foundation for Strategic and Social Research, pointed out in an interview with this reporter that China, with a population of more than 1.4 billion, cannot move towards development and prosperity without effective policies and development roadmap formulated by the Communist Party of China (CPC).

  Suwell has been engaged in journalism for more than 20 years and interviewed leaders of many countries. He is a well-known current affairs critic in Turkey. In 1998, Sewell became the chairman of the Marmara Foundation for Strategic and Social Studies and founded the Eurasian Economic Summit, aiming at establishing a dialogue mechanism and promoting regional dispute settlement and peaceful development.

  Su Wei’s unique life experience gave him a profound understanding of human development. He believed that the Communist Party of China (CPC) had distinct principles and characteristics, always adhered to the people-oriented development concept, and made unremitting efforts to promote equality of rights, opportunities and rules, which won wide support from the people. The people believe in the Party, and the Party takes the people as the center. The benign interaction makes China society full of vitality.

  In 2013, China put forward the initiative of building a "the belt and road initiative" by coordinating the overall situation at home and abroad and focusing on the future of human development. This initiative follows the principle of co-construction, co-construction and sharing, and is strongly recognized by Sowell. He said, "the belt and road initiative" is an important peace project, which closely links the east and west ends of Asia, promotes economic cooperation and cultural integration, and lays a new foundation for human civilization and progress. "Build ‘ The belt and road initiative ’ It is not only the need to develop the economy and achieve a win-win situation, but also the requirement of the times and peace. " In order to deeply understand and study how to build a "the belt and road initiative", Sowell visited China for more than 10 times, exchanged ideas with China scholars, and introduced them to people from all walks of life after returning home. In the opening speech of the 22nd Eurasian Economic Summit held in 2019, Sowell repeatedly mentioned the joint construction of "the belt and road initiative", and this initiative became one of the important topics of the summit.

  Sowell said that last year, in the face of the sudden COVID-19 epidemic, the China government quickly took effective measures to control the spread of the epidemic, and became the only major economy in the world that achieved positive economic growth, fully demonstrating its institutional advantages. Sowell told reporters that he and his wife were vaccinated with COVID-19 vaccine from China. He said with emotion: "In this fight against the COVID-19 epidemic, the government and people of China not only fought for their own country, but also provided a lot of support and help to other countries in the world, such as vaccines, medicines and equipment from COVID-19. China’s concept of building Community of Shared Future for Mankind is becoming an ideological driving force to encourage countries to work together to deal with the epidemic. "

  Sewell pointed out that it is a great historical achievement for a political party to last for a hundred years. As a century-old party, the Communist Party of China (CPC) is full of infinite vitality. I believe that with its unremitting efforts, China will make new contributions to the development of human civilization.

  Awad, Deputy Editor-in-Chief of Sudan’s Shout and an expert on international issues — —

  An active and promising member of the international community.

  Our reporter Shang Kaiyuan

  “中国共产党的历史,是一部为实现目标宗旨而不懈奋斗的壮丽史诗,每一个篇章都值得认真研读。”苏丹《呐喊报》副主编、国际问题专家阿瓦德表示,中国共产党在漫长岁月中取得的成就,与其领导人的品质和能力牢不可分,同党与各族人民的血肉联系密切相关。

  阿瓦德认为,正是因为把命运牢牢掌握在自己手中,中国实现了理想目标,发展成为世界第二大经济体。中国共产党把马克思主义基本原理同中国具体实践相结合,走出了一条中国特色社会主义发展道路。“在当代,习近平新时代中国特色社会主义思想是这一道路的最新成果,充分说明中国共产党和中国人民在实践、经验、思想等方面持续不断发展。”

  作为执政党,中国共产党采取切实有效的政策,鼓励人民群众开展创新活动,激发全社会的创新能力,为产业发展打开了广阔天地,在许多重要领域实现巨大飞跃。“发挥制度优势使中国科技快速发展,通过在战略性、基础性、前瞻性领域增加投入,中国提高了科研能力,并取得了一系列创新成果。”阿瓦德认为,中国对全球经济增长贡献巨大,在清洁能源、科技创新等领域的发展令人称赞。“我相信,中国人民将在中国共产党的领导下,信心百倍地贯彻执行党和国家的发展规划,实现中国梦。”

  Awad visited China for the first time in 2016 and participated in the first Asian-African Youth Festival. This experience provided him with an opportunity to get to know China on the spot. "The people of China have many advantages, such as seriousness and perseverance." Since then, he has visited China many times to participate in exchange activities, and his understanding of China is getting deeper and deeper. In awad’s view, the people of China are eager to know the world and hope to build a bridge of cooperation. the Communist Party of China (CPC) has also carried out constructive exchanges with political parties of various countries to promote cooperation and mutual trust between countries. "the Communist Party of China (CPC) is the largest political party in the world, and many political parties want to know their practical experience accumulated on the road to realizing the great rejuvenation of the nation." Awad said.

  Awad was deeply touched by China’s efforts to strengthen cooperation among countries in the world. China proposed to build a "the belt and road initiative" to promote policy communication, facilities connectivity, smooth trade, financial intermediation and popular support among countries. He said: "China is committed to pursuing common interests, realizing the common well-being of people of all countries and building a better world."

  During the epidemic prevention and control in COVID-19, China launched an initiative of uniting against the epidemic to the world, helping other countries to fight the epidemic with practical actions. Awad said: "This highlights that China is an active member of the international community and has a great influence on the just cause of the international community." At present, global economic recovery requires countries, especially major economies, to strengthen cooperation, and awad expects China to play a greater role in it.

  Bubacar Seyni Gagaha, Deputy Secretary of Propaganda of Niger People’s Socialist Party — —

  Not only maintain historical continuity, but also keep pace with the times.

  Our reporter Qiang Wei

  Bubacar Seyni Gagaha is the Deputy Secretary of Propaganda of the Niger ruling Party for Democracy and Socialism (PDPS) and the Director of the Archives Department of the Ministry of National Defense. In an interview with reporters recently, he said that he sincerely admired the Communist Party of China (CPC)’s century-long development. "Especially during the prevention and control of the COVID-19 epidemic, the world saw more clearly the institutional advantages of China under the leadership of the Communist Party of China, and the People’s Socialist Party also regarded the Communist Party of China (CPC) as a role model for political parties."

  In July 2017, at the invitation of the International Liaison Department of the CPC Central Committee, Gagaha led a youth delegation of the People’s Socialist Party to visit China and visit Beijing, Shanghai, Ningbo, Chengdu and other cities. Before the visit, the members of the delegation knew little about China, especially the Communist Party of China (CPC)’s ruling style. "Through this visit, we found that under the leadership of the Communist Party of China, the socialist democracy promoted by China is the most extensive, authentic and effective democracy. In China, the equal rights of the people are effectively guaranteed, and people of all ethnic groups are represented in the national legislature, and their legitimate rights and interests in all aspects can be safeguarded. " Gagaha said that another feature of China’s socialist democracy is the multi-party cooperation and political consultation system led by the Communist Party of China (CPC). "This system unites all forces to the greatest extent and breaks down obstacles for the sustainable development of China."

  这次访问给加加哈和全团成员留下了极为深刻的印象。“从回国那天起,我就一直想再次回到中国。每次别人问起我放长假希望去哪里,我的回答都是中国。中国有太多我想要进一步了解和学习的地方。”

  带着这样的想法,加加哈阅读了《习近平谈治国理政》《摆脱贫困》等书籍,经常浏览中国新闻媒体的法文版。加加哈说,通过不断增进对中国共产党的了解,他发现中国共产党具有许多显著特点。“第一,中国共产党提出的理论以实践作为支撑。只有这样的理论才能真正指导中国的建设实践,在此基础上制定的各项政策才符合中国实际需要。第二,中国共产党既保持了历史延续性,又做到与时俱进,领导人的治国理念一脉相承、不断发展。第三,中国共产党有严密的组织纪律以及坚定的理想信念,这保证了其长期有效运转,并始终明确执政目标。最后也是最重要的一点,中国共产党能够始终保持与人民群众的血肉联系。”加加哈指出,这些理论和实践经验对发展中国家政党加强自身建设很有帮助。

  In the interview, Gagaha told a story around him: "I chatted with a stranger while drinking tea at a street tea stall the other day. He told me that we should thank China. It is because of China that we can now have motorcycles running all over the street, watch TV and listen to radios that can be bought for one or two thousand CFA francs (about one hundred and twenty yuan). " Gagaha said: "This shows the influence of China on the development of Niger and Africa. The process of global industrialization has already started, but ordinary people in African countries have really begun to enjoy industrialized products more generally, which is inseparable from the role and influence of China’s rapid development in recent decades. "

  "The People’s Socialist Party has always regarded the Communist Party of China (CPC) as a rare true partner. We know that China and the Communist Party of China (CPC) really care about African countries and are really willing to help us develop. " Gagaha said with emotion.

  Layout design: Shen Yiling

International football La Liga comprehensive: Barcelona 1: 1 draw with Valencia.


Original title: International Football La Liga Comprehensive: Barcelona 1:1 draw with Valencia

During the 2023-2024 season, there were several competitions in the 17th round of the Spanish Football League. In a focus battle, Barcelona drew 1-1 away from Valencia.

On December 16th, Barcelona player De Jong (left) competed with Valencia player Sergi Canós. Xinhua news agency

Barcelona visited the Mestalla Stadium this round, Felix opened the scoring for the visiting team, and Hugo Guillamon equalized the score for the Bat Corps. After the draw, Barcelona ranked third in the standings with 10 wins, 5 draws, 2 losses and 35 points, still six points short of Gerona, the "leader" who missed one game.

In the first half, neither side achieved anything. In the 55th minute, Barcelona finally broke the deadlock, and Felix, who was unguarded, stabbed Rafinha’s pass into the goal from close range, helping the visiting team lead 1-0. In the 70th minute, Hugo Guillamon of Valencia smashed the net on the edge of the restricted area and rewrote the score to 1:1.

On December 16th, Barcelona player Pedri (top right) and Valencia player Guillamon (bottom) competed in the competition. Xinhua news agency

After that, Barcelona missed the opportunity twice, and the shots of Phelan Torres and Rafinha were saved by the Valencia goalkeeper. The score of 1:1 was maintained until the end.

In the other games of the day, Atletico Madrid lost to Athletic Bilbao 0-2, Getafe beat Seville 3-0 and Certa beat Granada 1-0 at home.

Recently, I want to buy a car and change it. The three most worthwhile cars in 2023 are coming.

In recent years, with the continuous development of automobile technology, many new models have been introduced by major manufacturers, some of which have attracted much attention at the end of the year. This paper will comprehensively analyze three high-profile models from different angles, namely Nissan Sylphy, Tesla Model Y and Volkswagen LaVida.

appearance design

First of all, let’s take a look at the design of these three models.

Nissan Sylphy is highly praised for its dynamic appearance. The body lines are smooth, dynamic and steady, giving people a visual impact with a sense of fashion and luxury. Tesla Model Y adopts a fashionable design concept, and its unique lines and bold appearance make it a beautiful landscape on the road.

Volkswagen LaVida attracts attention with its exquisite appearance, and every detail has been carefully carved, making the overall appearance more luxurious and atmospheric.

Luxury of interior

In addition to the appearance, the interior design of the vehicle is also an important factor to consider when buying a car. Nissan Sylphy also performed well in the interior, and the sense of luxury was beyond words.

Selected materials and exquisite craftsmanship make the interior space a private luxury space for drivers and passengers. The interior design of Tesla Model Y highlights the sense of fashion and technology. The large central control screen and high-quality interior materials give people a sense of the future. Volkswagen LaVida, on the other hand, takes its luxury interior as its selling point, and its wood grain decoration and high-grade seats make driving a luxury enjoyment.

Configuration richness

In terms of configuration, these three models also strive to stand out in the same class. Nissan Sylphy is rich in configuration, including advanced safety system, intelligent driving assistance and other functions, providing drivers with a more comprehensive car experience.

Tesla Model Y has attracted much attention for its leading electric vehicle technology. Its advanced automatic driving system and strong endurance make it one step ahead in technology configuration. Volkswagen LaVida, on the other hand, pays attention to safety performance and is equipped with advanced driver assistance system, which makes driving more secure.

Cost performance analysis

When buying a car, consumers often pay more attention to cost performance.

Nissan Sylphy shows excellent cost performance with its dynamic appearance, luxurious interior and rich configuration. Although the price of Tesla Model Y is high, its advanced electric vehicle technology and endurance offset the high price to some extent. Volkswagen LaVida provides a good choice for consumers with its plain price and rich configuration.

Comparison of endurance

In the current trend of electric vehicles, endurance has become a crucial indicator. Tesla Model Y stands out with its strong endurance, providing consumers with longer driving mileage, making electric vehicles a more practical means of transportation.

In contrast, Nissan Sylphy and Volkswagen LaVida are slightly inferior in this respect. Although they are sufficient in daily use, there is still room for improvement compared with the future development trend of electric vehicles.

Safety performance comparison

In the automotive field, safety performance has always been the focus of consumers’ attention.

These three models have excellent performance in safety performance. Nissan Sylphy has passed the advanced safety system and a number of safety tests to ensure the safety of drivers and passengers. Tesla Model Y provides drivers with more comprehensive protection with its intelligent driver assistance system and advanced collision safety technology.

Volkswagen LaVida also pays attention to safety performance and is equipped with a number of driver assistance systems to make driving more secure and reliable.

Based on the above analysis, Nissan Sylphy, Tesla Model Y and Volkswagen LaVida each have unique advantages in design, interior luxury, configuration richness, cost performance, endurance and safety performance.

When buying a car, consumers can weigh the advantages and disadvantages of these aspects according to their personal needs and preferences, and choose the model that best meets their own needs. With the continuous progress of science and technology, the automobile industry will also usher in more innovations and changes, and the future models will be more intelligent, environmentally friendly and safe, providing consumers with a richer driving experience.

Virtual Human Competition: Iflytek vs Pingping Intelligent, which is more suitable for you?

In recent years, with the development of artificial intelligence technology, virtual human, as a system based on human-computer interaction, has attracted more and more attention. In the virtual human market, Iflytek and Fengping Intelligent are well-known enterprises. Next, we will compare the virtual people of the two companies, and analyze them from the aspects of technology, popularity, cooperative enterprises, application scope, ease of operation and price.

First of all, from a technical point of view,Iflytek Virtual Human has adopted the leading natural language processing technology and artificial intelligence technology, and has the ability of semantic understanding and reasoning, which can provide more intelligent services.

However, the technical level of Fengping intelligent virtual human is relatively weak, lacking the support of key technologies such as deep learning and natural language processing.

Secondly, in terms of popularity and cooperative enterprises,As a well-known artificial intelligence enterprise, Iflytek has high popularity and influence in domestic and foreign markets, and has established long-term cooperative relations with many enterprises, which can provide customers with more comprehensive services. In contrast, Fengping Intelligence still has much room for improvement in terms of market visibility and cooperative enterprises.

Next, from the perspective of application scope and simplicity of operation,Fengping intelligent virtual human has a wider range of applications, which can be applied to a variety of industries and scenarios, such as education, medical care, hotels and so on.

The operation simplicity of Fengping intelligent virtual human benefits from its advanced technology and innovative functions. It is understood that Fengping intelligent virtual human can clone a digital avatar through a short video, and can control the digital avatar to complete video production, live broadcast and other tasks through simple voice or text instructions. This quick and simple operation greatly reduces the threshold for users to use virtual people, and at the same time improves the user’s experience.

In contrast, the operation mode of Iflytek Virtual Human is relatively complicated, which requires users to learn and train to give full play to its functions.

Therefore, the simplicity of operation of Fengping intelligent virtual human has also become a big advantage in the market. Users can get started quickly and complete various tasks quickly, saving time and energy and improving work efficiency.

Finally, in terms of price,The price of Fengping intelligent virtual human is relatively low, which is more close to the people and can meet the needs of small and medium-sized enterprises. The price of virtual human in Iflytek is higher, which is suitable for larger enterprises.

To sum up, Iflytek virtual human is far superior to Pingping intelligent virtual human in technology, popularity and cooperative enterprises. However, Fengping intelligent virtual human has more advantages in application scope, simplicity of operation and price. Therefore, users can choose their own virtual human products according to their own needs.

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 ~