Thread: Index Match Function

you have multiple entries for each state for the same year (one per month)
e.g. Alabama 1992 appears 12 times so match will return the first one it finds which is from row 9550
if that's what you want then
in i2 of sheet us_data
=INDEX(unemp!$K$1:$K$21632,MATCH(A2&C2,INDEX(unemp!$B$1:$B$21632&unemp!$D$1:$D$21632,0),0))
will return 140,613 for Alabama 1992
if you only want december ie month 12
=INDEX(unemp!$K$20626:$K$21632,MATCH(A2&C2,INDEX(unemp!$B$20626:$B$21632&unemp!$D$20626:$D$21632,0), 0))
will return 126306 for Alabama 1992