index - match - 1 value - 3 possible matches

[joel17]

I am currently trying to look up 1 value - which is a state and could have up to 3 matches with that state, where there are up to 3 different zip codes that I would like to return in order to do other formulas based on the 1-3 results. I would like to reference the look value on 1 tab and have it look up a table on another tab to bring back the result. Example

[TABLE="width: 381"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 5"]Tab 1[/TD]
[/TR]
[TR]
[TD]Address[/TD]
[TD]State[/TD]
[TD]Result 1 zip[/TD]
[TD]Result 2 zip[/TD]
[TD]Result 3 zip[/TD]
[/TR]
[TR]
[TD]Location 1[/TD]
[TD]AZ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Location 2[/TD]
[TD]AZ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Location 3[/TD]
[TD]AZ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Tab 2[/TD]
[/TR]
[TR]
[TD]Contact Person[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact Person 1[/TD]
[TD]AZ[/TD]
[TD]85099[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact Person 2[/TD]
[TD]AZ[/TD]
[TD]85117[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact Person 3[/TD]
[TD]AZ[/TD]
[TD]87144[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks for the help.