Help! IF function is too limited

R

Ringo

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?
 
B

Bob Phillips

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.
 
Top