Protect Your Work If you share workbooks with others then I am sure you have experienced someone inserting or deleting a sheet and t...

TRACKING FORMULA ERRORS in SPREADSHEETS Guest Post: J. Helstrom Spreadsheet formula errors may cause other calculations to also yield...

JOINING VLOOKUP FUNCTIONS TOGETHER Between the holidays, Ice Storms and dealing with my daughter's wisdom teeth removal, it has bee...

LOOKUP FUNCTION As I mentioned, I am writing a new Ebook on Lookup  Functions and am having a blast playing around with some of these for...

CHOOSE FUNCTION I am writing a new CPE EBook on advanced functions and starting with some of the lookup functions. I took a look at the ...