If cell 1 contains a number, then auto input contents in other cells

**MGRIFF12** · 03-19-2014, 04:32 PM

I am trying to make a shortcut to filling out checks for my work. Everyone(where) we write to checks to has a specified number. For the checks, we put in the specified number and address (street, city, state, and zip all in different cells).

I am wondering if there is a way to just put the specified number in a cell, and the other cells automatically fill with the address.

For example:
Frank is #390
123 Apple St.
Sunnyvale, FL 12345

If I punch 390 in cell A1, is there any way to auto fill the rest so that A2 is '123 Apple St.', cell A3 is 'Sunnyvale', A4 is 'FL', and A5 is '12345'?

**etaf** · 03-19-2014, 04:41 PM

if you have the full list in a table in excel

so in columns as listed a-b
#390 = 123 Apple St. Sunnyvale FL 12345

then you can lookup the value in A and return the value in B

can you post a sample file of your address info

**MGRIFF12** · 03-19-2014, 04:52 PM

Sample.xlsx
Thank you for responding! I attached a sample of the form I need to fill out (Sheet 1), and Sheet 2 is sample information.

I just want to know if there is a way to just type in the GL code on the top form, and have the address fill in automatically...

**etaf** · 03-19-2014, 06:36 PM

assuming the GL Code goes into cell D12

for the address use
=VLOOKUP(D12,Sheet2!A1:E6,2,FALSE)
for City/State/Zip Code use
=VLOOKUP(D12,Sheet2!A1:E6,3,FALSE)&"/"&VLOOKUP(D12,Sheet2!A1:E6,4,FALSE)&"/"&VLOOKUP(D12,Sheet2!A1:E6,5,FALSE)

you can change how its laid out
& is the concatenate command and so if you want spaces and other text, then change
&"/"&
to
&" / "&
adding spaces

see attached

**MGRIFF12** · 03-19-2014, 06:50 PM

Awesome, thank you so much!!!

**etaf** · 03-19-2014, 06:57 PM

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

If cell 1 contains a number, then auto input contents in other cells

LinkBack

Thread Tools

Rate This Thread

Display

If cell 1 contains a number, then auto input contents in other cells

Re: If cell 1 contains a number, then auto input contents in other cells

Re: If cell 1 contains a number, then auto input contents in other cells

Re: If cell 1 contains a number, then auto input contents in other cells

Re: If cell 1 contains a number, then auto input contents in other cells

Re: If cell 1 contains a number, then auto input contents in other cells

Thread Information

Users Browsing this Thread

Similar Threads

Combining the contents of multiple cells with user input

[SOLVED] Distribute contents of a cell into other cells according to number of characters

Auto applying text to a cell based on another cells input

[SOLVED] Validating contents of a cell on input based on the contents of another cell

Read last cell in column & limit number of cells to write and then clear contents

Bookmarks

Bookmarks

Posting Permissions