Forumla so if text is entered in one cell other text is automatically entered into the adjacent cell

[Apollo1988]

Hello,

First time poster, so please do not evicerate me

I am currently doing a survey analysis and spend a lot of time looking up what Polling District certain streets are in. I have a table with all the streets in one column and their corresponding polling districts in another, and I would like to get my spreadsheet to automatically add the relevant polling district for the street when the street is entered? Is there any way to do this?

The Polling districts are three letters JMA for example.

Yours,


Apollo

 

[NeonRedSharpie]

Look into the vlookup formula or the index/match combination. With sample data sets, we can help you write the formula.

 

[ExcelMercy]

Some sample data would be helpful.

I'm assuming the Addresses to Polling Districts are predetermined somewhere. Like:

Excel 2010

	A	B
1	Key
2	Address	Polling District
3	1234 Main Street	JMA
4	312 South Road	LMA
5	490 Washington Lane	TPE
6	798 South Main Street	LTE
7	2315 North Blvd	PLE
8	321 Chesterfield Road	MGE

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Because then you could do something:

=IFERROR(INDEX($B$3:$B$8,MATCH(D3,$A$3:$A$8,0)),"Not In Key")

In the E3 cell.

Excel 2010

	D	E
1	Input
2	Address	Polling District
3	798 South Main Street	LTE
4	2315 North Blvd	PLE
5	490 Washington Lane	TPE
6	321 Chesterfield Road	MGE
7	1234 Main Street	JMA
8	312 South Road	LMA
9	562 Hollywood Blvd	Not In Key
10	798 South Main Street	LTE
11	2315 North Blvd	PLE
12	490 Washington Lane	TPE
13	798 South Main Street	LTE
14	489 South Blvd	Not In Key
15	321 Chesterfield Road	MGE
16	1234 Main Street	JMA
17	312 South Road	LMA
18	490 Washington Lane	TPE
19	312 South Road	LMA

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​