Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in data automatically
Hello, I have sheet1 that contains names and addresses. On sheet2 I made a
drop down box to choose any of those names. Is it possible to have the correct address fill in automatically in the cell next to the one the name is in ? Thanks for any help, -Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in data automatically
Assuming Names n Addresses are listed in Sheet1's cols A and B
In Sheet2, Assuming the DV to select the name is in A1 down In B1, copied down: =IF(A1="","",VLOOKUP(A1,Sheet1!A:B,2,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kevin" wrote: Hello, I have sheet1 that contains names and addresses. On sheet2 I made a drop down box to choose any of those names. Is it possible to have the correct address fill in automatically in the cell next to the one the name is in ? Thanks for any help, -Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in data automatically
If the names are unique, you could use =vlookup() to retrieve the values from
Sheet1. =if(a2="","",vlookup(a2,sheet1!a:e,2,false)) This will look at the value in A2. If it's empty (no choice has been made), it'll return "" (a cell that looks empty). If there's a value in A2, it'll look at column A of sheet1. It'll return the second column in the A:E range (column B) for the first match in column A. Debra Dalgleish has lots of notes on =vlookup(): http://www.contextures.com/xlFunctions02.html (for =vlookup()) And you may want to use data|validation to restrict the values to just names in your list (column A in my sample formula). Debra Dalgleish has notes starting he http://contextures.com/xlDataVal01.html Kevin wrote: Hello, I have sheet1 that contains names and addresses. On sheet2 I made a drop down box to choose any of those names. Is it possible to have the correct address fill in automatically in the cell next to the one the name is in ? Thanks for any help, -Kevin -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in data automatically
Thank you both for the fast and informative responses, I really appreciate
it. Working great! -Kevin "Dave Peterson" wrote: If the names are unique, you could use =vlookup() to retrieve the values from Sheet1. =if(a2="","",vlookup(a2,sheet1!a:e,2,false)) This will look at the value in A2. If it's empty (no choice has been made), it'll return "" (a cell that looks empty). If there's a value in A2, it'll look at column A of sheet1. It'll return the second column in the A:E range (column B) for the first match in column A. Debra Dalgleish has lots of notes on =vlookup(): http://www.contextures.com/xlFunctions02.html (for =vlookup()) And you may want to use data|validation to restrict the values to just names in your list (column A in my sample formula). Debra Dalgleish has notes starting he http://contextures.com/xlDataVal01.html Kevin wrote: Hello, I have sheet1 that contains names and addresses. On sheet2 I made a drop down box to choose any of those names. Is it possible to have the correct address fill in automatically in the cell next to the one the name is in ? Thanks for any help, -Kevin -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in data automatically
Welcome, good to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kevin" wrote in message ... Thank you both for the fast and informative responses, I really appreciate it. Working great! -Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically filling in a formula in a cell | Excel Discussion (Misc queries) | |||
Filling a cell automatically when data is put in another cell. | Excel Worksheet Functions | |||
Filling a cell automatically when data is put in another cell. | Excel Worksheet Functions | |||
Automatically Filling In Corresponding Data from Another Worksheet | Excel Discussion (Misc queries) | |||
Automatically filling in data | Excel Discussion (Misc queries) |