{"id":973,"date":"2012-04-26T20:01:00","date_gmt":"2012-04-26T12:01:00","guid":{"rendered":"http:\/\/vm-officeblogs.cloudapp.net\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/"},"modified":"2022-12-16T12:56:18","modified_gmt":"2022-12-16T20:56:18","slug":"using-multiple-criteria-in-excel-lookup-formulas","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/","title":{"rendered":"Using multiple criteria in Excel LOOKUP formulas"},"content":{"rendered":"\n

Updated 12\/16\/2022: <\/strong>Stay up to date on the\u00a0latest from Excel<\/a>\u00a0and download\u00a0Excel templates<\/a>\u00a0today.<\/em><\/p>\n\n\n\n

If you want to look up a value in a table using one criterion, it’s simple. You can use a plain VLOOKUP formula. But if you want to use more than one criterion, what can you do? There are lots of ways to use several Microsoft Excel<\/a> functions such as VLOOKUP, LOOKUP, MATCH, and INDEX.\u00a0In this blog post, I’ll show you a few of those ways.<\/p>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"Hybrid\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Microsoft Excel<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Get a better picture of your data.<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tLearn more<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

Using two criteria to return a value from a table<\/h2>\n\n\n\n

Let’s look at a scenario where you want to use two criteria to return a value. Here’s the data you have:<\/p>\n\n\n

\n\t
\n\t\t

\n\t\t\tLookup function\t\t<\/p>\n\t\t\n\t\t\tLearn more<\/span> <\/span>\n\t\t<\/a>\n\t<\/div>\n<\/div>\n\n\n\n

\"Using<\/figure>\n\n\n\n

The criteria are “Name” and “Product,” and you want them to return a “Qty” value in cell C18. Because the value that you want to return is a number, you can use a simple SUMPRODUCT() formula to look for the Name “James Atkinson” and the Product “Milk Pack” to return the Qty. The SUMPRODUCT formula in cell C18 looks like this:<\/p>\n\n\n\n

=SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(D3:D13))<\/b><\/p>\n\n\n\n

What it does is look in the range B3:B13 for the value in cell C16, and in the range C3:C13 for the value in cell C17. When it finds both, it returns the value in column D, from the same row where it met both criteria.  Here’s how it will look:<\/p>\n\n\n

\n\t
\n\t\t

\n\t\t\tBuilt-in excel functions\t\t<\/p>\n\t\t\n\t\t\tLearn more<\/span> <\/span>\n\t\t<\/a>\n\t<\/div>\n<\/div>\n\n\n\n

\"Excel<\/figure>\n\n\n\n

It returns the value 1, which corresponds to the value in cell D4 (“James Atkinson” in row 4 and also “Milk Pack” in the same row), thus returning the value in column D from that row. Let’s change the value in cell C5 from “Wine Bottle” to “Milk Pack” to see what happens with the formula in cell C18:<\/p>\n\n\n\n

\"SUMPRODUCT<\/figure>\n\n\n\n

Because our formula found two lines where both criteria were met, it sums the values in column D in both rows, giving us a Qty of 6.<\/p>\n\n\n\n

This technique cannot be used if you want to look for two criteria and return a text result. For instance, this, would not work:<\/p>\n\n\n\n

\"Don't<\/figure>\n\n\n\n

You would be looking for the Name “James Atkinson” where the Qty is 1, and you’d like to return the Product name that matches these two criteria. This formula would give us a #VALUE error! Instead, you could use a formula using a combination of SUMPRODUCT, INDEX, and ROW functions, such as this one:<\/p>\n\n\n\n

=INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*ROW(C3:C13)),0)<\/b><\/p>\n\n\n\n

You use the SUMPRODUCT function to find out the row where both criteria are met, and return the corresponding row number using the ROW function. Then you use SUMPRODUCT in the INDEX function to return the value in the array C3:C13 that is in the row number provided. The result will be like this:<\/p>\n\n\n

\n\t
\n\t\t

\n\t\t\tUsing Lookup and multivalued fields in queries\t\t<\/p>\n\t\t\n\t\t\tLearn more<\/span> <\/span>\n\t\t<\/a>\n\t<\/div>\n<\/div>\n\n\n\n

\"Using<\/figure>\n\n\n\n

You could also do this using a different technique, such as this formula in cell C17:<\/p>\n\n\n\n

=LOOKUP(2,1\/(B3:B13=C16)\/(D3:D13=C18),(C3:C13))<\/b><\/p>\n\n\n\n

The result will be the same as in the previous solution. What this formula does, is divide 1 by an array of True\/False values (B3:B13=C16), and then by another array of True\/False values (D3:D13=C18). This will return either 1 or a #DIV\/0! error. If you use 2 as the lookup value, then the formula will match it with the last numeric value in the range, that is, the last row where both conditions are True. This is the “vector form” of the LOOKUP, so you can use it to get the corresponding value returned from C3:C13. I used 2 as the LOOKUP value, but it can be any number, starting at 1. If the formulas don’t find any match, you will, of course, get a #N\/A error!<\/p>\n\n\n\n

You could also use an array formula, using the MATCH function, like this:<\/p>\n\n\n\n

{=INDEX(C3:C13,MATCH(1,(B3:B13=C16)*(D3:D13=C18),0))}<\/b><\/p>\n\n\n\n

With this technique, you can use the MATCH function to find the row where both conditions are met. This returns a value of 1, which is matched to the 1 that is used as the lookup value of the MATCH function, thus returning us to the row where the conditions are met. Using the INDEX value, you can look for the value that is in the range C3:C13, which is in the row that was returned from the MATCH function. In this case, it was row 2, which corresponds to the second row in the range C3:C13.<\/p>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"Employees\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Task management in Microsoft 365<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Collaborate on shared Office documents, including Excel, Word, and PowerPoint.<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tGet started today<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

Using multiple criteria to return a value from a table<\/h2>\n\n\n\n

All of these examples show you how to use two criteria for lookups. It’s also easy to use these formulas if you have more than two criteria-you just add them to the formulas. Here is how the formulas would look if you add one more criterion:<\/p>\n\n\n\n

=SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(E3:E13=C18)*(D3:D13))<\/b><\/p>\n\n\n\n

=INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*(E3:E13=C18)*ROW(C3:C13)),0)<\/b><\/p>\n\n\n\n

=LOOKUP(2,1\/(B3:B13=C16)\/(D3:D13=C18)\/(E3:E13=C18),(C3:C13))<\/b><\/p>\n\n\n\n

{=INDEX(C3:C13,MATCH(1,(B3:B13=C16)*(D3:D13=C18)<\/b>*(E3:E13=C18),0))}<\/b><\/p>\n\n\n\n

Learn more<\/h2>\n\n\n\n

As you can see, depending on what’s in your data tables, you can use several different techniques using different Excel functions<\/a> to look up values. Enjoy applying these to your own Excel spreadsheets<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you want to look up a value in a table using one criteria, it’s simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I’ll show you a few of those ways.<\/p>\n","protected":false},"author":17,"featured_media":265732,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\nExcel Lookup formulas with multiple criteria | Microsoft 365 Blog<\/title>\n<meta name=\"description\" content=\"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Lookup formulas with multiple criteria | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-26T12:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-16T20:56:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Using multiple criteria in Excel LOOKUP formulas\",\"datePublished\":\"2012-04-26T12:01:00+00:00\",\"dateModified\":\"2022-12-16T20:56:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\"},\"wordCount\":900,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\",\"name\":\"Excel Lookup formulas with multiple criteria | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\",\"datePublished\":\"2012-04-26T12:01:00+00:00\",\"dateModified\":\"2022-12-16T20:56:18+00:00\",\"description\":\"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg\",\"width\":1200,\"height\":800,\"caption\":\"Small conference meeting in modern workspace.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using multiple criteria in Excel LOOKUP formulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Lookup formulas with multiple criteria | Microsoft 365 Blog","description":"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/","og_locale":"en_US","og_type":"article","og_title":"Excel Lookup formulas with multiple criteria | Microsoft 365 Blog","og_description":"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2012-04-26T12:01:00+00:00","article_modified_time":"2022-12-16T20:56:18+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","type":"image\/jpeg"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Using multiple criteria in Excel LOOKUP formulas","datePublished":"2012-04-26T12:01:00+00:00","dateModified":"2022-12-16T20:56:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/"},"wordCount":900,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/","name":"Excel Lookup formulas with multiple criteria | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","datePublished":"2012-04-26T12:01:00+00:00","dateModified":"2022-12-16T20:56:18+00:00","description":"Discover how to use the VLOOKUP, LOOKUP, MATCH, and INDEX functions in Microsoft Excel for multiple criteria.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2022\/10\/Ofc17_Meeting_012.jpg","width":1200,"height":800,"caption":"Small conference meeting in modern workspace."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/04\/26\/using-multiple-criteria-in-excel-lookup-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Using multiple criteria in Excel LOOKUP formulas"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/973"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=973"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media\/265732"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=973"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=973"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=973"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=973"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}