It turns out that Excel has evolved to XLOOKUP

Every weekend and holiday, I have to come here a few times to increase my new knowledge. I get up in the morning and go to YT to watch new films such as Lao Gao Ma Lian and have breakfast. The happiest thing is to do what I do, what is it? What I should do, what I am doing now can be said to be a waste of time, I can just be worthy of myself.

However, the first video was released a year ago. The content is so valuable and so high, and I admire it. After watching this Excel teaching, I feel that the period of my last job really made me feel ashamed. It was just a report. , or to take over what a colleague has done, although there is no new addition, and I don’t want to do something that can make it easier. It is completely a craftsman, doing things according to orders, and outputting A4 reports for everyone to see, but not allowed. If you exceed certain limits, you can only remark at most. Besides, I have only learned VLOOKUP and pivot analysis table, connected the two worksheets, calculated it, and it is enough to cope with it.

Now I know that Excel has evolved to XLOOKUP, which has almost replaced VLOOKUP. Unfortunately, I have already left, and I have no chance to learn new functions. If I want to make a report now, I really forget how to do it... Of course , it is possible to relearn. (laugh