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
Address	Polling District
1234 Main Street	JMA
312 South Road	LMA
490 Washington Lane	TPE
798 South Main Street	LTE
2315 North Blvd	PLE
321 Chesterfield Road	MGE

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Key[/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

</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
Address	Polling District
798 South Main Street
2315 North Blvd
490 Washington Lane
321 Chesterfield Road
1234 Main Street
312 South Road
562 Hollywood Blvd
798 South Main Street
2315 North Blvd
490 Washington Lane
798 South Main Street
489 South Blvd
321 Chesterfield Road
1234 Main Street
312 South Road
490 Washington Lane
312 South Road

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Input[/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]LTE[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]PLE[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]TPE[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]MGE[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]JMA[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]LMA[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]Not In Key[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]LTE[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]PLE[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]TPE[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]LTE[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]Not In Key[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]MGE[/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]JMA[/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]LMA[/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]TPE[/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]LMA[/TD]

</tbody>

Sheet1​