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

Suburb	Region State
Fairfield	XXX NSW

<tbody>
</tbody><colgroup><col><col></colgroup>

Suburbs Tab is as follows:
A B C
Suburb State Region

FAIRFIED	NSW	Sydney - South West
FAIRFIELD	QLD	Brisbane - South
FAIRFIELD	VIC	Melbourne - Inner

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[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