The excel team did an ama that turned into a bug reporting forum but there were some good ideas suggestions. One of the takeaways is I need to transition from vlookup to index/match. It’s funny, once we get comfortable with certain methods, we stick to them. I’ve never been that proficient with i/m, because I don’t use it. And therein lies the circular loop issue.
The most fun question was when someone asked for examples of people using excel for unusual things. There’s a tool that turns a picture into a spreadsheet using conditional formatting; there are excel games; animations using VBA and macros. The most awesome is Japanese artist Tatsuo Horiuchi who makes paintings in excel. Not simple paintings but extremely complex and beautiful drawings.