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

Apollo1988

New Member
Joined
Sep 10, 2014
Messages
1
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
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Look into the vlookup formula or the index/match combination. With sample data sets, we can help you write the formula.
 
Upvote 0
Some sample data would be helpful.

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

Excel 2010
AB
AddressPolling District
1234 Main StreetJMA
312 South RoadLMA
490 Washington LaneTPE
798 South Main StreetLTE
2315 North BlvdPLE
321 Chesterfield RoadMGE

<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
DE
AddressPolling 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
 
Upvote 0

Forum statistics

Threads
1,224,427
Messages
6,178,586
Members
452,860
Latest member
jroberts02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top