Automatic population of data.

Hello Friends

I have a spread sheet with two values – say like this

City Number City Name

100 Athens
101 Bucharest
102 Copenhagen
103 Dhanbad
104 New Delhi
105 Toronto
106 Las Vegas
107 Las Angeles
108 New York
109 Denver
110 Buffalo
111 Chennai
112 Bangalore

I want the user to input the City number and in the adjoining cell the name of the city should come up. Can someone tell me how I do this ?

Thanks for your help, as always.

Hello.

You are going to want to create a named list for the city number/city name.

So wherever you have your table (column 1 city number, column 2 city name) select all the data and press CTRL-F3. Type "CityKey" for the name and press OK.

Now put this in cell B3:

=IF(A3="","",VLOOKUP(A3,CityKey,2,FALSE))

This looks up what is in cell A3 and returns the value of the city name based on the name you defined. If there is nothing in Cell A3, it displays nothing.

So it matches whatever is in cell A3 with the match in CityKey, and then returns the second column value of that table, which is the name.


Hope this helps.

Originally Posted by hoffey

Hello.

You are going to want to create a named list for the city number/city name.

So wherever you have your table (column 1 city number, column 2 city name) select all the data and press CTRL-F3. Type "CityKey" for the name and press OK.

Now put this in cell B3:

=IF(A3="","",VLOOKUP(A3,CityKey,2,FALSE))

This looks up what is in cell A3 and returns the value of the city name based on the name you defined. If there is nothing in Cell A3, it displays nothing.

So it matches whatever is in cell A3 with the match in CityKey, and then returns the second column value of that table, which is the name.


Hope this helps.

Hi,

What should I use, if I have a combination to look at two columns to populate the 3rd column as per the attachment.

Regards,
Avinash

Hi Guys,

Can any of the pros assist me with this situation??

AB