ChatGPT can assist with complex Excel formulas, including a VLOOKUP plus IFERROR to return not listed when no match appears.

If it involves numbers, there’s a good chance I’ve already opened Excel and used one of these features for it.

New! Sign up for our free email newsletter.

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...