The trucking industry is worth hundreds of billions of dollars per year. Uber is going after this market with Uber Freight, an online platform that matches truckers with...Technologyread more
Drone strikes attacked an oil processing facility at Abqaiq and the nearby Khurais oil field on Saturday.Marketsread more
Trump said oil would be released if needed to keep the market well supplied and he would expedite the approval of pipelines in Texas and other states.Marketsread more
Saudi Aramco is aiming to restore by Monday about a third of its crude output that was disrupted after drone attacks on two key oil facilities, The Wall Street Journal...Marketsread more
Apple's new iPhones can still send texts, download apps, and make video calls, but the company spends a lot of time and effort marketing its new phones as powerful photography...Technologyread more
Some U.S. manufacturers say tariffs, if targeted, will help address longstanding unfair trade practices like intellectual property theft.Traderead more
Supporters of a $15 minimum wage ballot initiative in Florida argue the state's inflation-tied pay hikes have not gone far enough.2020 Electionsread more
Saudi Arabia shut down half its oil production Saturday after drone strikes hit the world's largest oil processing facility in an attack claimed by Yemen's Houthi rebels.Politicsread more
Trusii's hydrogen water machines were supposed to help users with their health problems, but customers claim the company is involved in a giant scam.Technologyread more
The decoupling of the world's two weightiest economies seems as inescapable as its extent and global impact remains incalculable.Politicsread more
BlackBerry has reinvented itself to become a leader in securing mobile communications and in embedded communications. Next year it plans to roll out new products. CEO John...Evolveread more
No matter what changes Microsoft makes to its software or how much fresh competition it faces across its suite of products, one thing remains true: spreadsheet junkies use Excel.
Shipped for the first time 34 years ago, Excel is the default product used for entering data and performing calculations, and it's continued to be a key piece of Microsoft Office, which is still a huge revenue driver at the company.
So when Microsoft announces one of its biggest Excel updates in years, no matter how wonky, power users start chattering. On Wednesday, Microsoft introduced a feature called XLOOKUP, which was designed to address some of the shortcomings of one of Excel's most popular features, VLOOKUP.
Since releasing version 1.0 of Excel for Macintosh in 1985, the software included VLOOKUP to help users carry over information from one part of a spreadsheet to another. According to a Microsoft blog post on Wednesday, it was the third most-used function, after SUM and AVERAGE. The V stands for vertical, a reference to the function's ability to retrieve information in vertical columns. A similar function called HLOOKUP works with data that's in horizontal rows.
VLOOKUP had some notable limitations. Results defaulted to an approximate match of what the user was looking for, instead of the exact match. XLOOKUP fixes that.
Also, VLOOKUP could only spit out data that's to the right, and not to the left, of the reference column, so users would often have to rearrange their data to use the function. With XLOOKUP, users can draw on data that's to the left or right, and it combines VLOOKUP and HLOOKUP into a single function.
Joe McDaid, Excel's senior program manager, told CNBC by email that to get around VLOOKUP's constraints, advanced users would turn to a combination of other functions, INDEX/MATCH, but they can be complex for most people to use.
XLOOKUP is "more powerful than INDEX/MATCH and more approachable than VLOOKUP," McDaid wrote.
The change received some praise on Twitter.
Rhett Weller, a senior finance manager at Cisco, uses Excel to help predict revenue. He's looking forward to using XLOOKUP. It's currently only in beta with limited access for some people in the Microsoft Office 365 Insider program. Microsoft will release it more widely in the next few weeks.
"It's just a simple formula with a simple array lookup that anybody can use," Weller said in an interview after the update was announced. "It's pretty exciting."
Correction: A previous version of this story had a typo in the date of Excel's initial release. It was 1985.