+ Reply to Thread
Results 1 to 2 of 2

Pulling Location from master list and populating table?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    Pulling Location from master list and populating table?

    I have a table full of premises (Column A) and on a separate table, I have a master list of each premise's city. I'm trying to find a way to populate column B with the cities corresponding to each premise, then column C with the country corresponding to that city. The same restaurant does appear on multiple lines but it;s all alphabetical so they appear consecutively.

    I attached an example of what I am looking for, it's a simple example but hopefully I can use it on my actual table, which has more premises/countries and cities.

    Thank you in advance, and if I am lacking any information or require clarification, please let me know.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,709

    Re: Pulling Location from master list and populating table?

    Use the Vlookup function as shown in your file which is attached
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populating data from a master list
    By joesport5 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2013, 03:32 PM
  2. [SOLVED] Pulling data from a master list
    By Kevin Stewart in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-27-2013, 03:54 PM
  3. [SOLVED] Need Help Populating A Master List For Wedding Invite List
    By cdwelch4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 07:01 PM
  4. Need Help Populating A Master List For Wedding Invite List
    By cdwelch4 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2013, 01:10 PM
  5. Populating a master list
    By jmprudencio in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 03:48 PM
  6. Populating a master list from a daily log
    By ryangodammit in forum Excel General
    Replies: 1
    Last Post: 02-25-2012, 12:55 AM
  7. Populating a Master List
    By Petrov in forum Excel General
    Replies: 0
    Last Post: 06-06-2007, 11:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1