I've been helping readers find the best deals for over five years. If you’ve never worked with spreadsheets before, just opening Microsoft Excel can feel intimidating. The program has so many ...

is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft is overhauling Excel with the ability to support custom live data types.

Q. I love using Excel but know I’m not getting the most out of it. What would you recommend to boost my Excel productivity quickly? A. I get questions like this a lot. People like many Excel features ...

lookup_value is the value we want Excel to search for. lookup_array is where we want Excel to search for the lookup value. return_array is where the data exists that we want Excel to return.