上海贵族宝贝龙凤楼

　　The 44th World Heritage Conference opened at 19: 00 on the 16th in Fuzhou, Fujian Province, China. Affected by the global COVID-19 epidemic, the conference was held online in Fuzhou.

　　 What is World Heritage?

　　Up to now, the total number of cultural relics and natural landscapes selected for the World Heritage List has reached 1,121.China has 55 world heritages, ranking first with Italy.What exactly is a "world heritage"? What conditions do you need to be selected for the World Heritage List?

　　World Heritage refers to the rare and irreplaceable wealth recognized by UNESCO and the World Heritage Committee, and is a cultural relic and natural landscape with outstanding significance and universal value recognized by all mankind.

　　△ In 1987, China’s Great Wall and Mount Tai were listed in the World Heritage List for the first time.

　　World heritage includes three categories: world cultural heritage (including cultural landscape), world natural heritage and dual heritage of world culture and nature. In 1972, UNESCO adopted the Convention for the Protection of the World Cultural and Natural Heritage, which established a permanent and effective system based on modern scientific methods for the joint protection of cultural and natural heritage with outstanding universal value, and established the World Heritage List in 1976. China formally joined the Convention for the Protection of the World Cultural and Natural Heritage on December 12, 1985. In 1987, six world heritages, including the Great Wall and Mount Tai, were included in the World Heritage List for the first time.

　　△ In July 2019, "Liangzhu Ancient City Site" became the 55th World Heritage Site in China.

　　At present, 55 world heritages in China have been selected into the World Heritage List. What conditions do you need to meet to stand out? First of all, it must have outstanding universal value in the world. For this reason, the Convention Operation Guide gives 10 standards of world heritage, including six standards for "cultural heritage" including artistic value, architectural achievement and cultural inheritance, and four standards for "natural heritage" including nature and species diversity and natural scenery. If the projects declared by various countries meet any of these standards, it is possible to enter the World Heritage List.

　　The World Heritage List makes the world pay more attention to the protection of cultural and natural heritage. Since the 18th National Congress of the Communist Party of China, China has successively promulgated more than 70 local laws and regulations, which together constitute the legal protection system of world cultural heritage. For example, when tourists visit cultural relics and historic sites, they will face legal accountability for scribbling.

　　 News Link Protection of Intangible Cultural Heritage: Protecting Cultural Diversity

　　On the basis of the classification, protection and utilization of cultural heritage and natural heritage in the World Heritage List, on October 17, 2003, UNESCO adopted the Convention for the Protection of Intangible Cultural Heritage, and the protection of intangible cultural heritage has also received extensive participation from all over the world. At present, there are 42 intangible cultural heritage projects in China, ranking first in the world. China has established a four-level directory system at the national, provincial, municipal and county levels, and more than 100,000 representative items of intangible cultural heritage have been identified, and a large number of precious, endangered and valuable intangible cultural heritage have been effectively protected. (CCTV reporter Ma Li)

　　Abstract: The history of the Communist Party of China (CPC) is also a history of learning. Learning is a strong driving force for the Communist Party of China (CPC) to improve himself. It is the continuous improvement of learning ability that promotes the development and growth of the Communist Party of China (CPC). The Communist Party of China (CPC) people rely on learning to go to today, and they must also rely on learning to go to the future. Over the past 95 years, the Communist Party of China (CPC)’s successful experience in improving learning ability is a valuable spiritual wealth for the construction of learning-oriented political parties in the future.

　　[Keywords:] the Communist Party of China (CPC) learning ability learning-oriented political party [Chinese library classification number] D26 [document identification code] a

　　The history of the Communist Party of China (CPC) is also a history of learning.

　　It is a fine tradition of our party to attach importance to and be good at learning. Learning is a strong driving force for the Communist Party of China (CPC)’s development and self-improvement. It is in the process of learning that the Communist Party of China (CPC) constantly improves his leadership level and ruling ability. The birth of the Communist Party of China (CPC) is the great achievement of advanced elements studying Marxism seriously. After the outbreak of War of Resistance against Japan, faced with the new complicated situation, the Party’s theoretical literacy, policy level and knowledge ability need to be improved urgently. Mao Zedong proposed "to turn the whole Party into a big school". The learning activities of the whole party and the subsequent rectification movement have improved the Marxist theoretical level of the whole party and laid a solid foundation for winning the victory of the new-democratic revolution.

　　Before and after the founding of New China, the CPC Central Committee demanded that party member cadres should make great efforts to learn how to manage and build cities. Deng Xiaoping once gave a positive evaluation: "On the eve of national victory, Comrade Mao Zedong called on the whole party to study again. We didn’t study badly that time. After entering the city, we quickly recovered our economy and successfully completed the socialist transformation. " In the new period of reform and opening-up, the outstanding problem facing China in catching up and building a socialist modern country is the shortage of talents. Deng Xiaoping deeply feels that "there are too few professionals who know all walks of life". How to solve this problem? The best way is to study. In this process, the Communist Party of China (CPC) has gradually established a top-down learning system: first, establish and improve the learning system for on-the-job leading cadres at the provincial and ministerial levels; The second is to hold a theoretical seminar for senior leading cadres; The third is to create a system of collective learning of the central leadership; The fourth is to strengthen the rotation training of cadres in party schools. In the 21st century, China has a deeper understanding of the word "learning type" which originated in the west. In September 2004, the Fourth Plenary Session of the 16th CPC Central Committee proposed to "focus on the theoretical and professional study of leading cadres, promote the study of the whole party, and strive to build a learning-oriented political party". The 18th National Congress of the Communist Party of China put forward learning, service and innovation as the unified goal of the construction of the ruling party, which is a profound grasp of the law of the construction of the ruling party and a major theoretical innovation.

　　Scientific arrangement of learning content ensures the pertinence and effectiveness of party member cadres’ learning.

　　Faced with rich cultural knowledge, the choice of learning content is very important. Different times and tasks, the content of learning is definitely changing, but there are some common contents that must be persisted in learning for a long time. Mao Zedong once pointed out: "Without revolutionary theory, historical knowledge and a deep understanding of the actual movement, it is impossible for a political party that guides a great revolutionary movement to win." In other words, theory, history and knowledge closely related to work are eternal learning themes.

　　Theoretical study should always be in the first place. To strengthen the party’s ideological and theoretical construction, the first task is to equip and innovate the theory, and learn to observe, analyze and solve problems by using Marxist standpoints and methods. Learning theory is the foundation of firm ideals and beliefs. Some cadres in party member are indifferent to their ideals and beliefs, and their spiritual level is not high. They even "don’t believe in Marxism-Leninism and believe in ghosts and gods". One of the important reasons is that they don’t pay attention to studying scientific theories and improving their ideological and theoretical literacy. The Communist Party of China (CPC)’s belief in communism and Socialism with Chinese characteristics’s belief are based on the scientific theory of Marxist dialectical materialism and historical materialism. Only when party member cadres firmly believe in this scientific theory can they establish lofty ideals and firmly adhere to the guiding position of Marxism. Theoretical study is the basis of theoretical innovation. Every major study activity in the history of the Party has promoted the theoretical innovation of the Party. Learning promotes innovation, and innovation calls for learning. The benign interaction between them is valuable experience in the construction of learning-oriented political parties.

　　历史蕴含着丰富的智慧。古人云：“欲知大道，必先为史。”无论中国历史还是世界历史，都有治国安邦的智慧，都有兴衰更替的经验教训。积极学习人类社会的一切文明成果，科学分析和善于借鉴其他国家的先进经验，才能把别国的现代化先进成果转化为我国经济社会发展的助推力。读史使人明智，历史知识是政治智慧的前提，人们可以从历史的宝藏中获取人生智慧和精神动力。无论什么岗位什么工作的党员，学习历史是必修课。习近平总书记从不同角度多次指出，历史是最好的教科书、历史是最好的老师、历史是最好的清醒剂，中国革命历史对共产党人来说是最好的营养剂。

　　结合工作需要学习相关知识是建功立业的基本功。学习过程中，要坚持普遍性要求与个人爱好相结合的原则，在追求党组织整体建设目标的前提下，根据党员自身爱好和兴趣科学安排学习内容，使学习的内在动力与客观要求有机地结合起来。应坚持干什么学什么，缺什么补什么，认真学习经济、政治、文化等方面知识，不断提高知识化、专业化水平。努力用一切科学的新思想、新知识、新经验丰富自己，从而不断提高理论素养、领导水平和精神境界。

　　坚持理论联系实际的学风，确保学以致用

　　In the history of the party, there have been two wrong styles of study: one is dogmatism, that is, copying Marxist books and copying other countries’ models; The other is empiricism, that is, ignoring theoretical study and theoretical guidance, often falling into transactionalism and losing the way forward. The basic experience gained by the Party after paying a heavy price is that we must adhere to the excellent style of study of integrating theory with practice, learn to use scientific theories to understand and analyze reality, use theories to guide practice, and test and develop theories in practice, so as to truly apply what we have learned, promote learning and learn from each other.

　　The purpose of learning is all about application. Learning should be carried out closely around the development requirements of the cause of the party and the state, starting with a correct understanding and practical solution to new problems arising in social development, with problem learning. Learning is to solve problems, not to show up. The people are the creators of history, so they should be good at learning from the people and draw inexhaustible power from their wisdom and strength to promote the cause. The Party’s previous studies have been carried out on the basis of promoting the development of the cause and safeguarding and realizing the fundamental interests of the people, thus winning the support of the people. If you are divorced from the masses, sit and talk about things without the interests of the masses, or talk about theories without promoting career development, such learning is meaningless. The ongoing study and education of "two studies and one doing" emphasizes that the foundation lies in learning and the key lies in doing, that is, we should persist in applying what we have learned, do what we have learned, do what we have learned, and enhance our working skills and improve our ability to solve practical problems through learning.

　　Establish and improve the learning guarantee mechanism

　　Learning depends on consciousness as well as system. Perseverance is the most important thing in learning. If there is no certain institutional norms to restrain and habits cannot be formed, it will be difficult to persist in learning such a long-term and retreat task. For party building, learning is not only an individual behavior, but also an organizational behavior. An important goal of building a Marxist learning-oriented political party is to establish a perfect learning system, standardize learning and make learning a habit.

　　The institutional guarantee to improve the learning ability is to link the learning situation of leading cadres with the assessment and promotion of cadres, form a learning-oriented employment orientation, build an institutional system of assessment and evaluation of party organizations’ learning, improve the system of learning, evaluation and examination, make the learning of party organizations form a long-term mechanism, and strive to create an atmosphere in which party member cadres love reading, read well and be good at reading. We must persist in taking theoretical literacy and learning ability as the important basis for selecting and appointing leading cadres, and let the broad masses supervise the learning situation of leading bodies and leading cadres, and select cadres who are truly learned, truly understood, truly believed and truly used to leading positions. It is necessary to strengthen the application of assessment results, and in the evaluation and reward of cadres, we should not only examine the virtue and diligence, but also pay attention to the study situation.

　　Learning has gradually shifted from "engaging in activities" to "grasping the normal state", forming a long-term learning guarantee mechanism. According to the needs of the development of the situation, it is necessary to concentrate on learning for a period of time. However, learning is a long-term task, especially in the era of rapid development of science and technology. If you don’t learn, you will drop out. Therefore, you should persevere and form an institutional mechanism to ensure continuous learning. For example, establish and improve the training system, scientifically arrange pre-job training, professional training, promotion training, theoretical training, etc. Establish and improve various forms of thematic education system, and pay attention to the working mechanism of carrying out study and education on major festivals; For the study of leading cadres at all levels, it is also necessary to establish and improve the system of transforming learning achievements, and through various forms such as special seminars, collective exchanges, and research reports, the achievements of learning and education will be put into practice through decision-making bodies in time. The CPC Central Committee emphasizes that "two studies and one doing" is not an activity, but to highlight normal education and form regular, normalized and institutionalized inner-party learning and education.

　　Leading cadres take the lead in learning, which is the key to building a learning party.

　　The people are the creators of history, while leading cadres are the "key minority" and play a vital role in the process of social development. The construction of a learning party is a major project related to the development of the party and the country, and it is also a retreat work. If the "key minority" does not attach great importance to it and play a leading role in demonstration, it will be difficult to achieve practical results. Mao Zedong and other proletarian revolutionaries of the older generation are not only advocates and organizers of learning, but also practitioners. Their diligent actions and knowledgeable demeanor are examples for the whole party to learn. Since the reform and opening up, the central leadership has insisted on collective learning, which has set an example for the whole party and played a huge role in promoting and demonstrating the learning atmosphere in the whole party. Leading cadres should assume three roles in the process of learning and building a learning-oriented party organization, namely, meticulous organizer, active promoter and conscious practitioner.

　　回顾95年的历史，中国共产党强调学习的话语始终没有改变。在党的群众路线教育实践活动和“三严三实”专题教育取得显著成效的基础上，在全体党员中开展“两学一做”学习教育，就是把党的历史上重视学习、善于学习的优良传统弘扬光大。正如习近平总书记指出的：“好学才能上进。中国共产党人依靠学习走到今天，也必然要依靠学习走向未来。”

　　（作者为北京师范大学马克思主义学院教授）

　　【参考文献】

　　①习近平：《在中央党校建校80周年庆祝大会暨2013年春季学期开学典礼上的讲话》，《人民日报》，2013年3月3日。

　　

ChatGPT, a chat robot based on artificial intelligence technology, has recently become a hot topic. According to the latest survey, 50% of enterprises in the United States are already using ChatGPT, and 48% of them even let it work instead of employees. This news triggered a heated discussion among netizens, and everyone discussed and chatted.

In this digital era, the advantages and values of ChatGPT also appear. As an advanced technology application, ChatGPT can improve the efficiency and quality of enterprises and individuals, save time and cost, and create more value and possibilities. For example, in the field of customer service, ChatGPT can provide users with services and solutions 24 hours a day. In the field of code, ChatGPT can quickly write high-quality code; In the field of copywriting, ChatGPT can generate attractive copywriting according to the target audience and scenes, and so on. Moreover, the increasing popularity of ChatGPT also shows that the demand for intelligent services in human society is growing.

However, we also need to see the problems and challenges existing in ChatGPT. As a robot based on data and algorithms, ChatGPT is not perfect. It may have errors, deviations, loopholes and so on, and it is difficult to control its behavior and consequences. For example, in terms of data security, ChatGPT may disclose or abuse the private information of users or enterprises; In terms of ethics, ChatGPT may violate or destroy social norms and values; In terms of legal liability, ChatGPT may cause or participate in some illegal or infringing acts and so on.

Break a million users in a week and have 100 million users in two months.

Of course, ChatGPT needs to constantly improve its technology and functions in the future development, especially in data security and ethics. ChatGPT developers need to seriously think about chatting.

In this ever-changing era of science and technology, the appearance of ChatGPT has brought many new opportunities and challenges to mankind. As human beings, we need to master the control ability of science and technology, use it with the right attitude and methods, and keep up with the development and changes of science and technology to maintain our competitiveness and innovation ability.

Therefore, ChatGPT is both a friend and an enemy of mankind. It has brought us unprecedented convenience and efficiency, but it also requires us to use and manage it more rigorously and carefully. I don’t know if you are expecting or resisting the pressure that AI will bring us in the future.

"

Ambarella’s CV3 AI domain controller SoC series (hereinafter referred to as "AMBA", NASDAQ: AMBA, a semiconductor company specializing in AI vision chips) was awarded the annual automobile product award in the 2022 Electronics Industry Award, and was highly praised in the annual semiconductor product category.

The Electronic Industry Award is sponsored by British @CIE magazine, which aims to recognize the best professionals, products, projects and companies in the entire electronic industry.

In the annual "Electronics Industry Awards" of "Components in Electronics", a well-known British media (magazine/website), Ambarella won the "2022 Product Award" by virtue of CV3 automotive AI domain controller SoC.

Anba’s award-winning CV3 series realizes centralized AI sensing processing (including high-pixel vision processing, millimeter-wave radar, laser radar and ultrasonic radar), multi-sensor deep fusion and regulation and control of autonomous vehicles by integrating multiple sensors on a single chip. As a result, ADAS L2+ to L4 automatic driving systems have a higher level of environmental awareness.

The selection method of "Electronic Industry Award" is to invite experts in the industry to vote online, and add the votes of an independent expert jury to finally get the winner. The award has entered its fifth year and will soon become an important activity in the industry, opening the door for new business opportunities.

About Anba

Anba’s products are widely used in artificial intelligence computer vision, video image processing, video recording and other fields, including video security, advanced driver assistance system (ADAS), electronic rearview mirror, driving recorder, driver and cabin intelligent monitoring, intelligent car unmanned driving and robot application, etc. Anba’s high-performance, low-power AI processor provides ultra-high definition image processing, video compression and powerful neural network processing. It can extract valuable data from high-resolution video and radar information, and it plays an important role in the fields of intelligent perception, sensor fusion and central domain control processing system. For more information, please visit www.ambarella.com.

How many content creators keep up late to cut videos of liver explosion? Have you ever thought that one day we can get rid of this heavy work and be done by AI instead? In fact, judging from the development status of AIGC industry, the above imagination is entirely possible to become a reality, and it may be in the near future.

From the perspective of Xiaobian, the content editing industry will go through three stages of development, and we are currently in the initial state of the second stage.

The first stage: pure manual editing

In the traditional sense, it is the manual editing of staying up late to burst the liver. The quality of editing depends on the level of editors and the time spent. This stage is characterized by "high labor intensity" and "a lot of repetitive work". It is precisely because of this pain point that with the progress of technology, the pain point of "excessive physical labor" was first solved by AI. After all, what AI is best at is simple and repetitive labor.

The second stage: manual +AI collaboration stage

AI is good at simple and repetitive movements, but AI is not only good at simple and repetitive movements. So the development of video editing industry has entered the stage of "manual +AI collaborative editing". From the clipping used in our daily life to some commercial clips in the toB field, we can see that AI smart clips are active among them.

Watson, an artificial intelligence system of IBM, edited the trailer for the sci-fi thriller movie Morgan as early as 2016. The technical team collected 100 thriller movie trailers for Watson to machine learn. Watson’s unique training model tagged the details of these trailers, such as picture, audio, scene connection, sound configuration, etc., decomposed and learned one by one, and assigned them to its own creative model. Finally, Watson successfully used the trained data model to select materials from 90-minute movies, and edited them into a 6-minute trailer, which was successfully put into use for film announcement.

Up to now, this kind of intelligent matching tool platform has evolved to the extreme, and ordinary users can simply use AI function for intelligent editing. On the local AI intelligent graphic-to-video platform, one frame per second is the highest, and the user inputs the edited copy. AI will automatically perform intelligent picture matching from the platform’s powerful online material library, presenting its own intelligent video generation results in seconds, and matching all-round details such as pictures, dubbing, subtitles, etc. in one stop. Users can directly export and use it with simple confirmation, especially in the production of popular science content and simple sharing content with low editing difficulty.

At the same time, AI, as an auxiliary tool of intelligent editing, is also blooming in the development direction. At present, all kinds of AI-enabled editing software emerge in an endless stream, some of which support intelligent graphic-to-video, some of which focus on recording and cutting, and some of which can simulate the voice of the user for dubbing modification and adjustment. The "scoop" can also be quickly corrected through AI. In short, the current AI intelligent editing industry is in a thriving development trend. It can be said that with the progress and integration of technology, AI will be fully involved in the field of intelligent editing, and our video editing work will be greatly released.

The third stage: pure AI editing stage

In the future, AI will run video editing in the whole process, even the currently difficult "audit" work. This is a bold idea put forward by Xiaobian, which has certain subjectivity. The main idea of this view is that the compliance and rigor of AI creation are unmatched by human editing. At present, AI editing is still in the primary stage, so human assistance is needed in content review and sensitive screen screening. However, the speed and capacity of AI learning is far beyond that of human beings. With a large number of legal provisions and review rules being learned by AI, the whole process of video editing will be completed by AI.

AI can even avoid problems such as audit omission caused by human fatigue and negligence. Even, while recording and cutting, real-time synchronization, the completion of shooting is a piece of export, which is not completely impossible. In addition to the research and development of AI automatic editing software, there may be AI shooting intelligent hardware devices, workstations and other products in the future, so as to maximize the convenience of video production. The development of AI technology makes us more daring to imagine its bright future.

In addition, what really makes Xiaobian feel that the intelligent editing industry will eventually rise vigorously is that the existing problems "seem" are not problems, and AI will eventually break them one by one with strong technical strength. When the AI industry was just beginning to develop, we were worried that AI would replace some human jobs. At that time, the prediction given by the technology industry was that "art, creativity and other jobs that need to exert human imagination will not be replaced".

However, at present, AI’s original painting has become a reality, and the field of artistic creativity has become the first industry to be impacted. It can be seen that AI’s "imagination" is far beyond our imagination, and the speed of technology iterative update is much faster than expected. The future is really coming.

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 ~