Return Value with Multiple Criteria

[Mcook13]

I am trying to return a value (a date) based on 2 criteria.

Column A has a purchase order, column J has a part #, and column E has the date.

All columns have some repeating numbers, but the 2 criteria together makes it unique.

Because of the sheet layout I can't use vlookup so I would have to use Index Match.

Essentially what I am trying to have the formula do is look in column A for this PO#, then look in Column J for this exact part number which is tied to that particular PO#, and return the date that is tied to that PO and part number.

I can't figure out how to use Index Match to return the date based on the 2 criteria of PO# and Part#. Please help and thank you

 

[AhoyNC]

Try one of these formulas.
If you have Excel 2010 or later formula in cell D11 of the example below.
If you have an earlier ver. of Excel then the formula in cell E12. This formula must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	PO #				Date					Part #
2	1				4/5/2019					25
3	2				4/12/2019					66
4	4				4/22/2019					35
5	6				3/25/2019					26
6	1				5/5/2019					15
7	6				5/12/2019					44
8
9
10	Find			Date
11	PO	1		5/5/2019
12	Part	15			5/5/2019
Sheet

 

[DanteAmor]

Try this "regular" formula

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:96.95px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:51.33px;" /><col style="width:96.95px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >E</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Purchase Order</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Date</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Part #</td><td > </td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Purchase Order</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Part #</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Result Date</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">123</td><td style="text-align:right; ">10/04/2019</td><td style="text-align:right; ">1</td><td > </td><td style="text-align:right; ">123</td><td style="text-align:right; ">2</td><td style="text-align:right; ">11/04/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">123</td><td style="text-align:right; ">11/04/2019</td><td style="text-align:right; ">2</td><td > </td><td style="text-align:right; ">456</td><td style="text-align:right; ">203</td><td style="text-align:right; ">15/04/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">123</td><td style="text-align:right; ">12/04/2019</td><td style="text-align:right; ">3</td><td > </td><td style="text-align:right; ">789</td><td style="text-align:right; ">1001</td><td style="text-align:right; ">16/04/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">456</td><td style="text-align:right; ">13/04/2019</td><td style="text-align:right; ">201</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">456</td><td style="text-align:right; ">14/04/2019</td><td style="text-align:right; ">202</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">456</td><td style="text-align:right; ">15/04/2019</td><td style="text-align:right; ">203</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">789</td><td style="text-align:right; ">16/04/2019</td><td style="text-align:right; ">1001</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">789</td><td style="text-align:right; ">17/04/2019</td><td style="text-align:right; ">1002</td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >N2</td><td >=SUMPRODUCT(($A$2:$A$9=L2)*($J$2:$J$9=M2)*($E$2:$E$9))</td></tr></table></td></tr></table>