Vlookup with two coloumms

[niladri20052006]

Hi All,

I have two columns consisting of City and State names like below:

<table width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="2"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">Dallas</td> <td style="width: 48pt;" width="64">TX</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Phoenix</td> <td>AZ</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Portland</td> <td>OR</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Seattle</td> <td>WA</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Washington</td> <td> DC</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Chicago</td> <td>IL</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Atlanta</td> <td>GA</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Chicago</td> <td>IL</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">New York</td> <td>NY</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Los Angeles</td> <td>CA</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Denver</td> <td>CO</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Atlanta</td> <td>GA</td> </tr> </tbody></table>
I have another sheet where I will have to match those contacts where city and states names will match.


What will be the Vlookup formula?

 

[hiker95]

niladri20052006,

See:

VLOOKUP for Combined Values
http://www.contextures.com/xlFunctions02.html#combine

 

[Comfy]

=INDEX(VALUEStoRETURN,Match(1,(CityLookupRange=A1)*(StateLookupRange=A2),0))

Confirmed with Ctrl+Shift+Enter