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

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

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