Crerating a If Statement with Multiple Vlookups

[chriskwillard]

I am trying to create a formula that will allow me to look at country and state in order to determine territory.

I have on the first tab Country as column I and the state as G
on the Vlookup tab I have country as column A, state as B and territory as C

Ideally I want it to look at the country, find it then look at the state to determine the territory.

That said some times the country does not have a state and these for would solve territory based on that.
[TABLE="width: 192"]
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[PhilW_34]

Hello,

Can you add a column before your data to do this? One solution is to combine the country & state into one column and then vlookup against that to find your territory. Example: =I2&G2. Then lookup against that column to find the territory. In the territory column, you would then use soemthing like =VLOOKUP(A2&B2,Added column,3,false). Instead of a 3, you'd just have to count over to the column you want.

I'd need more information like what column your territory is in to be more specific. I'm happy to help though.

Phil

 

[chriskwillard]

Perfect, that worked brilliantly.