• About the site - Computer News Deals.com
  • Computer News Deals.com is a web portal with very unique concept of news blended with other important aspects of computer and internet technology.
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
Related News
Ez1095 Software Makes It Easy to Mail out 1095 Forms In Time
Platinum Plus Services Introduces Advanced Data Recovery Solutions for their Clients
12 Google Camera tips everyone can use
How Cortana in Edge can help you find context for images