Index Matching multiple criteria

[ardykav]

Hi All,
I have a column called region that needs to look up a tab (Suburbs)with all suburbs and states in Australia and return a certain region for that suburb,

However as some suburbs duplicate i need to index match 2 seperate columns. So the XX term below under region should return the value "Sydney - South West"

All help greatly appreciated

Tab one looks like so, Region is where i need to put the formula:

A B C[TABLE="width: 343"]
<tbody>[TR]
[TD]Suburb[/TD]
[TD]Region State[/TD]
[/TR]
[TR]
[TD]Fairfield[/TD]
[TD] XXX NSW[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

Suburbs Tab is as follows:
A B C
Suburb State Region[TABLE="width: 689"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FAIRFIED[/TD]
[TD]NSW[/TD]
[TD]Sydney - South West[/TD]
[/TR]
[TR]
[TD]FAIRFIELD[/TD]
[TD]QLD[/TD]
[TD]Brisbane - South[/TD]
[/TR]
[TR]
[TD]FAIRFIELD[/TD]
[TD]VIC[/TD]
[TD]Melbourne - Inner[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[rconverse]

This link should help.

http://www.mrexcel.com/forum/excel-questions/635806-lookup-multiple-values.html#post3154940

 

[ardykav]

That worked great, thanks a lot