|Title||Detecting problematic lookup functions in spreadsheets|
|Authors||Felienne Hermans, Efthimia Aivaloglou, & Bas Jansen|
|Publication||Delft University of Technology|
Spreadsheets are used heavily in many business domains around the world. They are easy to use and as such enable end-user programmers to build and maintain all sorts of reports and analyses. In addition to using spreadsheets for modeling and calculation, spreadsheets are often also used for creating reports and dashboards: combining data from different sources and creating overviews.
For this, lookup functions can be used: they search for a value in a range and return a corresponding row or column. Lookup functions are common: according to recent research the
In this paper we investigate the use of lookup functions in more detail. We analyze lookup functions within the newly released Enron spreadsheet corpus. The results show that:
The user has sorted the cells in
When this occurs, no error message or warning is given.