| Home : March 17 2016 Computer News : Use INDEX and MATCH for simple database queries in Excel |
|
Use INDEX and MATCH for simple database queries in Excel |
March 17, 2016
Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen at once—which means all in memory at once—the Excel databases had to be really small: multiple fields with few records, or few fields with a lot of records; and minimal calculations.VLOOKUP (vertical) and HLOOKUP (horizontal) were the only functions available to query a database for specific information. For example, you could query to find and extract all records that contained sales greater $1000 but less than $5000—but only on flat files (only one database matrix).To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/2999860/software/use-index-and-match-for-simple-database-queries-in-excel.html#tk.rss_howto
|
|
|
|
|