Automatic population of data.

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