Author: David H. Ringstrom
Many users rely on VLOOKUP for basic look-up functionality in spreadsheets, but are often unaware of ways to improve the integrity of this venerable function. In this session Excel expert David H. Ringstrom, CPA introduces the VLOOKUP function, and then quickly goes beyond the basics. Discover what can go awry with VLOOKUP, how to future-proof the function, and explore alternatives such as MATCH/INDEX, SUMIF, SUMIFS, SMALL/LARGE, MIN/MAX, and OFFSET.
David’s materials cover Excel 2016, 2013, 2010, and 2007. When applicable, some slides include alternate instructions for Excel 2003. In this presentation, he demonstrates techniques in Excel 2010, as he finds it’s presently the version most widely utilized by Excel users. David’s detailed handouts serve as reference tools you can fall back on after completing one of his courses. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Publication Date: October 2015
Designed ForPractitioners who rely on look-up functions within their spreadsheets.
NASBA Field of Study
Computer Software & Applications (3 hours)