Use INDEX and MATCH for simple database queries in Excel

The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.
microsoft excel logo primary
Rob Schultz

Note: When you purchase something after clicking links in our articles, we may earn a small commission. Read our affiliate link policy for more details.

JD Sartain is a technology journalist from Boston. She writes for PCWorld, Network World, CIO, & several other tech magazines.

Coupon Codes