Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a specific address from a list if the contents of cell A1=x
Cell A1 is for school name. Used Data Validation to provide a drop down list
to choose school name. Cell A2 is for school address. Would like a school's address (from a list) to be inserted when that school's name is selected in A1. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a specific address from a list if the contents of cell A1=x
=IF(A1="","",VLOOKUP(A1,School_address_table,2,0))
where School_address_table is a table with the school's name in the leftmost column and the address in column 2 For instance if you put all the school names in Sheet2 column A and their respective addresses in column B it would look like =IF(A1="","",VLOOKUP(A1,Sheet2!A:B,2,0)) Lookup VLOOKUP in help -- Regards, Peo Sjoblom "Anne" wrote in message ... Cell A1 is for school name. Used Data Validation to provide a drop down list to choose school name. Cell A2 is for school address. Would like a school's address (from a list) to be inserted when that school's name is selected in A1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cell contents, know cell address | Excel Discussion (Misc queries) | |||
Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
How do i insert a Address Bar kind of drop down list within MS Exc | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |