| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help! IF function is too limited
Hi! I've created a drop-down list of cities in a cell, under which there are two more cells to be filled out with the address and zip codes corresponding to each of the cities. How can I do this, knowing that the original list is a three-column list made of city-address-zip? -- Ringo ------------------------------------------------------------------------ Ringo's Profile: http://www.excelforum.com/member.php...o&userid=27502 View this thread: http://www.excelforum.com/showthread...hreadid=470178 |
|
#2
|
|||
|
|||
|
Use VLOOKUP into the original; list using the DV value
=VLOOKUP(B1,$M$1:$O$100,2,False) and then with an index of 3. -- HTH Bob Phillips "Ringo" wrote in message ... Hi! I've created a drop-down list of cities in a cell, under which there are two more cells to be filled out with the address and zip codes corresponding to each of the cities. How can I do this, knowing that the original list is a three-column list made of city-address-zip? -- Ringo ------------------------------------------------------------------------ Ringo's Profile: http://www.excelforum.com/member.php...o&userid=27502 View this thread: http://www.excelforum.com/showthread...hreadid=470178 |
|
#3
|
|||
|
|||
|
Ringo: Put your "original list" on a separate worksheet, and use a vlookup.
See... http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Ringo" wrote in message ... Hi! I've created a drop-down list of cities in a cell, under which there are two more cells to be filled out with the address and zip codes corresponding to each of the cities. How can I do this, knowing that the original list is a three-column list made of city-address-zip? -- Ringo ------------------------------------------------------------------------ Ringo's Profile: http://www.excelforum.com/member.php...o&userid=27502 View this thread: http://www.excelforum.com/showthread...hreadid=470178 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Linear Mode
