上海贵族宝贝龙凤楼

Yichexun On April 22nd, Weibo, the official of Wangwang Automobile, said that Wangwang U8 Off-road Player Edition will be officially launched on April 25th. In addition, we learned that Wangwang U7 will also be released at the same time, and the new car will be positioned as a million-class new energy flagship car, which will be equipped with easy four-way platform technology and provide four wheels and four motors.

Look up to U8 Off-Road Player Edition

Looking up to the U8 cross-country player version, the overall design is not much different from the ordinary version, but it adds an unmanned cabin on board, and is equipped with the original wading hose and AT tires. At the same time, some decorative covers have been added to the front engine compartment cover of the new car to make it look more off-road features. It is worth mentioning that, after the unmanned engine room is added, the height of the vehicle reaches 2034mm, and the width of the whole vehicle is slightly increased compared with the ordinary version, reaching 2095 mm.

In addition, the off-road player version is also equipped with in-vehicle satellite communication. This configuration adopts the industry-leading satellite communication scheme to provide a more complete communication means for vehicle communication. The cross-country player version of satellite communication is deeply integrated with the car, which can support the use of the car and mobile phone terminals, and also support the portability and practicality when leaving the car. And in places where the ground mobile network and fixed network can’t cover, the cross-country player version of satellite communication can also provide two-way voice call and two-way short message communication, so as to realize a safer car-linked network and enhance the active safety capability.

Its roof is equipped with a vehicle-mounted UAV garage jointly developed with DJI, which has four advantages: automatic power connection, auxiliary clamping, intelligent humidity control, waterproof and dustproof. The vehicle-mounted UAV located in the UAV library has six functions: one-button take-off, intelligent power exchange, one-button blockbuster, one-button landing, intelligent return flight and take-off following.

In terms of power, the U8 off-road player version will be equipped with a 2.0T four-cylinder range extender with a maximum power of 180kW; The car will adopt a four-motor four-wheel drive system, with a comprehensive power of 880 kW and a maximum torque of 1280 Nm. The vehicle will be equipped with a 49.05kWh lithium iron phosphate battery pack. Under CLTC working conditions, the pure battery life is 180 kilometers and the comprehensive battery life is 1000 kilometers.

Look up at U7

Looking up at U7, it is positioned as a million-class new energy flagship car. Its appearance adopts the family language of "dimension door", and the whole new car is in a downward posture, which makes its front face more recognizable with the family’s iconic headlight group modeling. In addition, the roof is equipped with a lidar. In terms of body size, the length, width and height of the new car are 5265*1998*1517mm respectively, and the wheelbase reaches 3160 mm. In addition, due to the body flow control technology and the optimized design of several pneumatic accessories, the drag coefficient of U7 is only 0.195Cd.

In terms of power, it is hoped that U7 will be equipped with easy quad platform technology, providing four wheels and four motors, and the maximum power of a single motor is 240 kW. The battery is equipped with lithium iron phosphate battery produced by Xiangyang Fudi Battery Co., Ltd.

On the occasion of bidding farewell to the old and welcoming the new.

Why not go out and explore our city?

Subway travel is green and convenient.

The next three-day interval is coming ~ ~ ~

Traffic interval of each line during New Year’s Day holiday

In order to ensure that citizens and friends can travel with peace of mind during holidays, Qingdao Metro analyzes the characteristics of passenger flow on New Year’s Day in advance and formulates special transport capacity guarantee measures. During this period, spare trains are arranged for each line, and additional trains are organized according to the passenger flow to replenish the transport capacity in time. The driving intervals of each line during the New Year holiday are as follows:

Optimizing transportation organization to ensure passengers’ travel

Qingdao Metro is guided by passenger flow demand, combined with the historical passenger flow law, fully studies the transportation demand, and optimizes the peak coverage period of May 4th Square Station, Fushan Station and Yan ‘erdao Road Station, and the peak capacity period lasts until 22:00. At the same time, we will focus on the changes of passenger flow from 20:00 to the end of operation. In case of ground passengers gathering, we will respond to passengers in a timely manner, relieve the pressure of local large passenger flow and avoid passengers staying.

Warm reminder: During the holidays, the operation hours of each station of the network will remain unchanged. Passengers who take the subway at night are advised to make travel plans in advance and arrange the travel time reasonably to avoid missing the last bus. If you need to transfer, please know the last bus time of the transfer line in advance.

Travel guide for warm winter market

Jazz Garden Winter Jazz Town

Time: from December 1, 2023 to January 7, 2024, every Friday to Sunday and January 1, 2024.

Venue: Former site of Belgian Consulate and courtyard of Guo Moruo’s former residence.

Travel route: Take Metro Line 3 to Taipingjiao Park Station, and exit B is within walking distance.

Winter fairy tale market

Time: from November 30, 2023 to January 1, 2024, from Thursday to Sunday and January 1, 2024.

Venue: Qingdao Museum of the Former Site of German Governor’s Building (Qingdao Guest House)

Travel route: Take Metro Line 4 to Signal Mountain (Affiliated Hospital of Qingda University) Station, and exit B2 is within walking distance.

Travel reminder

1. According to the Catalogue of Articles Prohibited and Restricted in Qingdao Rail Transit, it is forbidden to carry fireworks products, such as fireworks bombs, fireworks (including cold light fireworks), firecrackers, smashing cannons, starter paper, black powder, pyrotechnics, fuse, and "steel wool fireworks" when entering the station and taking the bus, as well as products with fireworks effect, and it is forbidden to carry them with length, width and height.

It is restricted to carry kitchen knives, fruit knives, dinner knives, scissors, craft knives, tool knives, etc. when entering the station or taking the bus, the blade part of the kitchen knife should be less than 20 cm, and the blade parts of other single items should be less than 10 cm. In addition, under the condition of intact packaging or taking other necessary protective measures, one single item can be carried in a limited amount, and the cumulative limit can not exceed three. If you carry sharp and blunt objects such as axes, hammers, steel (iron) files, awls (sharp objects) and iron bars, the length should be less than 25 cm, and if the packaging is intact or other necessary protective measures are taken, you can carry one single product in a limited amount, and the cumulative limit should not exceed three.

2. The passenger flow during holidays may be large, and people in the car may feel hot. Please increase or decrease your clothes according to your personal physique when getting on and off, and please take your belongings with you when getting off.

3. Go out for fun If you encounter bad weather and need to enter the station before the station leaves, you can call the station through the APP- Love Reservation function of Qingdao Metro, contact the staff to open the door in advance and wait at the station to avoid the wind, rain and cold.

4. If you encounter any problems or difficulties during the ride, you can contact the station staff or call the Qingdao subway service hotline 0532-55770000, and we will help you wholeheartedly.

Wave goodbye to 2023

Embrace 2024

Qingdao Metro wishes everyone.

a new year

May peace be with you always.

May happiness be with you always.

2024

Long Xing snipe dádá.

Original title: "New Year’s Day three-day subway train plan is coming ~ ~ ~ with a guide to warm winter market"

Read the original text

In the new era of electrified and intelligent automobiles, the international competitiveness and influence of China automobile enterprises are constantly improving. In order to promote the transformation from China manufacturing to China creation, China needs to create a brand-new design discourse system with its own characteristics.

On December 6th, the 10th Anniversary Forum of 2023 International Automobile Design and Geely Design was held in Shanghai. Dozens of influential figures covering production, learning, research and media were invited to attend and discuss with Geely how "good design has the power to change the world".

"Design is crucial. Design is not only an important reference standard for consumers to choose products, but also a key factor to determine product quality and the core competitiveness of Geely Automobile. " Yan Jiayue, CEO of Geely Automobile Group, said so.

According to reports, since its establishment in 2013, Geely Design has taken it as its responsibility to promote China’s independent automobile design in the new era. From "Damei China Car" to the rise of China’s independent design, to "Geely Yinhe" taking the lead in creating a new paradigm of China design in the era of smart electric. Geely constantly drives China automobile to climb the value peak again and again with its design, which affects the trend of automobile design in China and even the world.

Among them, Geely Yinhe E8 is the way out for Geely’s design-not compromising the existing conditions, constantly fighting against the entropy increase of design, and finding a beautiful order in the disorderly pattern.

Liu Ning, president of China Industrial Design Association, said: "We are very happy to see that it is an outstanding representative of an independent brand like Geely who is developing into a smart electric travel and energy service technology-based enterprise with global design competitiveness and influence, and constantly winning the recognition of the international community and global consumers."

Facing the opportunities and challenges of the times, China’s automobile design must change from single-point breakthrough to system capacity improvement. As Liu Ning said, "The design of new energy vehicles in China is not only the design of a single model, but also the design of the whole system, the whole value chain and the whole industrial chain".

If China’s automobile design wants to establish its own voice in the world, it needs to cooperate with all parties inside and outside the industry to participate in the promotion. The independent brand represented by Geely will promote the deep integration of Industry-University-Research, cultivate the future new force of China automobile design, and run out of the "acceleration" of independent training of talents.

In this forum, Geely Design, together with China Academy of Fine Arts, released the White Paper on China Automobile Design Discourse System (First Edition) in the field of automobile design in China, aiming at exploring the forward-looking thinking of China automobile design theory and system construction under the great changes. The release of this white paper has supplemented and improved the research system of automobile design in China, or it will become a landmark stop in the design history of automobile industry in China.

This year is the tenth year for Geely to explore the road of design. In the future, Geely Automobile will continue to contribute to the "good design" proposal of the world automobile development process and lead the industry to a new height in the development of the global automobile industry.

[Text/Song] Recently, Lin Shi, Secretary General of Intelligent Networked Automobile of China-Europe Association, met with Ji Lianying, co-founder of Mu Niu Technology, at the first private board meeting, and presented a letter of appointment to Ji Lianying to hire him as an intelligent networked automobile expert of China-Europe Association. Subsequently, the two sides exchanged in-depth technical information, development strategy and direction of Muniu Technology.

Ji Lianying received his Ph.D. from Beijing Institute of Technology in 2009. He has worked in embedded systems, human perception technology, artificial intelligence algorithms and other research institutions such as China Academy of Sciences and National University of Singapore. He used to be the technical director of Wuxi Microsense Technology Co., Ltd., and developed the first full-body motion capture system in China. Before he founded Mu Niu, he worked in the University of Chinese Academy of Sciences. Muniu Technology was established in Kansas, USA in May 2015, and the Beijing R&D Center was also established in July. The name of Muniu Technology comes from Muniu Liuma —— The Muniu Liuma invented by Zhuge Liang and others in the Three Kingdoms period is the embryonic form of intelligent transportation. The Muniu team took this as an incentive, embraced the intelligent era and paid tribute to China’s intelligence and wisdom. Muniu Technology has a combination of Chinese and American genes, which has avoided the early exploration stage and directly started to exert its strength in the field of 77GHz. It has been at the forefront of technology from the beginning and has achieved fruitful results.

Ji Lianying said at the meeting: "The core founding teams of the company all graduated from the Institute of Radar Technology of Beijing Institute of Technology and have more than ten years of research and project experience in radar. The company has been focusing on the research and development of millimeter-wave radar, and has profound technology and research and development strength in broadband antenna, MIMO and signal processing, and is at the leading level in the industry. Has more than ten patents. "

Ji Lianying said: "In the radar market, the passenger car market is the largest, but this market is basically monopolized by international manufacturers. In the field of commercial vehicles, foreign manufacturers disdain to do it, which is a very big blue ocean for domestic manufacturers. In the field of autonomous driving, the demand for driverless technology is relatively high. "

Lin Shi, secretary-general of China-Europe Association Intelligent Networked Automobile, pointed out that as a startup company, Muniu Technology has faster and stronger execution compared with large companies, so it may be faster than large companies in the innovation and creation of the same new technology. The popularization of ADAS to low-end cars requires higher cost performance and more practical technical support. China has both the largest manufacturer of low-end cars and a highly innovative enterprise like Muniu Technology, which is the weight to participate in the global automobile market competition.

Lin Shi, Secretary-General of China-Europe Association Intelligent Networked Automobile, is looking forward to the future development of Muniu Technology. He hopes that Muniu Technology will "escort" China’s new energy automobile industry by relying on the "hard power" of its own enterprises in the intelligent era.

Football is the most popular sport in the world, and the income of famous stars is also the top level in the world. Cristiano Ronaldo’s sky-high annual salary of $200 million now also shows the popularity of football, and this popularity is worldwide, so it is easier to increase income. Of course, not every player can enjoy the high salary. Playing football is also a profession, and the income level will be distinguished according to the ability. Therefore, the low-income people in football occupy a large proportion, so the gap between the rich and the poor of athletes is still very large.

Recently, Sportico, a sports business media, published a set of information. In 2022, the top 100 athletes in the world earned the highest income. Among them, football, as the most popular sport, occupied 12 places in the top 100, and basketball, one of the three big balls, also occupied a large proportion.

Among the top 10 sports athletes, there are 3 football players, all of whom are in the top 5. Messi’s salary of $72 million plus business endorsement of $50 million, with a total income of $122 million, ranks second. Cristiano Ronaldo, who has not yet moved to a local Saudi team, ranks third with a total income of $115 million. In 2023, Cristiano Ronaldo’s annual salary will reach $200 million, and his total income will rise sharply.

Neymar ranks fourth with a revenue of $103 million, and the top four football players occupy three seats, which proves that football stars have higher commercial value and football is more popular. Other top 100 footballers included Mbappé (US$ 254.88 million), Bell (US$ 304.33 million), Azar (US$ 413.79 million), Iniesta (US$ 533.50 million), Salah (US$ 573.42 million) and Levan (US$ 633.00 million).

In 2022, the American basketball player James ranked first in terms of athletes’ income. Although his annual salary was only $36.9 million, only half of that of Messi last year, his commercial contracts were as high as $90 million, and the commercial contracts were generally more and more, so James’ income was also increasing, making him a unique player in the world sports world.

Messi and Cristiano Ronaldo’s income is also unique in football. Even at the age of 38 or 36, they are still the most attractive players in football. Mbappé, of course, because of his age advantage, has the meaning of catching up with others. The total annual salary of Mbappé’s contract can reach 200 million, but it includes signing fee, loyalty bonus and so on, so it is not included in the list. However, if Mbappé wants to achieve the success of Messi and Cristiano Ronaldo, it still needs to maintain a long-term and stable state. Of course, Messi is a well-deserved king, both in honor and income, especially after winning the FIFA World Cup Qatar 2022 championship.

"

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 ~