shmiggs_2010
New Member
- Joined
- Jul 2, 2014
- Messages
- 3
I have a workbook that I use as a template to import into a billing program. The only issue with is that the software we use, has its an odd naming protocol for the tax areas. I was able to export all the data into a workbook.
I need a formula that is able to search for the State, then the City, and output the Tax Area. There were a couple of promising solutions but they involved numbers, and unfortunately our software doesn't associate the cities to any numbers.
This is an array formula that I found on exceltactics.com, but it uses a number to output a result.
{=INDEX(A4:C1159,MATCH(1,(A4:A1158=A2)*(B4:B1158=B2),0),4)}
This is a sample of how I have things set up, there are about 2500 rows of cities we bill and would really like a solution.
<tbody>
</tbody>I hope I explained myself well enough, thank you!
I need a formula that is able to search for the State, then the City, and output the Tax Area. There were a couple of promising solutions but they involved numbers, and unfortunately our software doesn't associate the cities to any numbers.
This is an array formula that I found on exceltactics.com, but it uses a number to output a result.
{=INDEX(A4:C1159,MATCH(1,(A4:A1158=A2)*(B4:B1158=B2),0),4)}
This is a sample of how I have things set up, there are about 2500 rows of cities we bill and would really like a solution.
| State (input) | City (input) | Tax Area (result) |
| AL | Auburn | =INDEX(A4:C10,MATCH(1,(A4:A10=A2)*(B4:B10=B2),0),3) |
| State (static info) | City (static info) | Tax Rate/Area (static info) |
| AL | AUBURN | AUBURN AL |
| AL | BALDWIN | BALDWIN AL |
| CA | LOS BANO | LOS BANOCA |
| CA | SOUTH SA | SOUTH SACA |
| GA | BALDWIN | BALDWIN GA |
| IA | DES MOIN | DES MOINIA |
<tbody>
</tbody>
