Index Match Function

[chaz0789]

Hi all,
I need some help with a multiple criteria index match function. I need it to look for two criteria, and then give me my output. Below is what i'm working with.


The X's are what i need to fill in

1 JACKSON-HOUSTON

<tbody>
</tbody>

Date	My Price	DAT Price	My Ship Count
FY17 (01) - NOV	X	X	X
FY17 (02) - DEC	X	X	X
FY17 (03) - JAN	X	X	X

<tbody>
</tbody>

My data looks like below

Look Up	Year Month	My Price	DAT Price	My Ship Count
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56

<tbody>
</tbody>

How would i link the two together? It needs to look at the 1 JACKSON-HOUSTON and then Year-Month column to input my price.

 

[oldbrewer]

The X's are what i need to fill in
1 JACKSON-HOUSTON
Date	My Price	DAT Price	My Ship Count
FY17 (01) - NOV	X	X	X
FY17 (02) - DEC	X	X	X
FY17 (03) - JAN	X	X	X
My data looks like below
Look Up	Year Month	My Price	DAT Price	My Ship Count
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
name1	FY17 (02) - DEC	$1.100	$2.19	46
name2	FY17 (02) - DEC	$1.104	$2.16	36
1 JABBER	FY17 (02) - DEC	$1.108	$2.13	26
I assume the lower table has many more names in the first column
so sort by first column ascending then year month ascending
Look Up	Year Month	My Price	DAT Price	My Ship Count
1 JABBER	FY17 (02) - DEC	$1.108	$2.13	26
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
name1	FY17 (02) - DEC	$1.100	$2.19	46
name2	FY17 (02) - DEC	$1.104	$2.16	36
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
by printing out blanks if first column is not a match with A3 you are there

<colgroup><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[chaz0789]

The X's are what i need to fill in
1 JACKSON-HOUSTON
Date	My Price	DAT Price	My Ship Count
FY17 (01) - NOV	X	X	X
FY17 (02) - DEC	X	X	X
FY17 (03) - JAN	X	X	X
My data looks like below
Look Up	Year Month	My Price	DAT Price	My Ship Count
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
name1	FY17 (02) - DEC	$1.100	$2.19	46
name2	FY17 (02) - DEC	$1.104	$2.16	36
1 JABBER	FY17 (02) - DEC	$1.108	$2.13	26
I assume the lower table has many more names in the first column
so sort by first column ascending then year month ascending
Look Up	Year Month	My Price	DAT Price	My Ship Count
1 JABBER	FY17 (02) - DEC	$1.108	$2.13	26
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
name1	FY17 (02) - DEC	$1.100	$2.19	46
name2	FY17 (02) - DEC	$1.104	$2.16	36
1 JACKSON-HOUSTON	FY17 (01) - NOV	$1.92	$2.25	66
1 JACKSON-HOUSTON	FY17 (02) - DEC	$1.96	$2.22	56
by printing out blanks if first column is not a match with A3 you are there

<tbody>
</tbody>

Thank you for the reply. However, i'm not understanding. Why would i need to sort it? There are many more names, but i just need the formula to go if jackson-houston and FY17 (01) - NOV then 1.92 is the value for my price. The jackson is a list with multiple names to select from. i'm trying to populate the data for a chart that will update when i select a new name.

 

[chaz0789]

I figured it out, thanks for the help everyone. Below is the formula I used just for reference.

=INDEX(Data!C:C,MATCH(Chart!$A$1,IF(Data!$B:$B=Chart!$A5,Data!$A:$A),0))

Control+Shift+Enter to make it an array