+ Reply to Thread
Results 1 to 2 of 2

Automatically populate data based on another cell

  1. #1
    Registered User
    Join Date
    Sydney, Australia

    Automatically populate data based on another cell

    Hi there,

    Im trying to automate data to go into a cell based on information from other cells. I want to be able to have the document automatically assign a country name based on data from another cell and a few parameters.

    For example i want column B in the attached document to be able to identify the country based on input from column H. But - the catch is there may be a number of inputs from column H that would relate to a country. For example column H may have ZBIF, ZPIN or ZPED, which would all relate to New Zealand. Or it could have NBIF, HARB, VAST, SODA which would all relate to Australia etc. Its easier to do it this way as the Regions dont really reflect the country's - its more where the operations centre are. Sometimes the operation centres move across countries / regions - and it gets confusing to manage. So it would be easier for me to set it up based on op centres. I can then change any peremeters based on that.

    Any help you can provide would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    Cibolo, TX
    MS-Off Ver
    Excel 2016

    Re: Automatically populate data based on another cell

    Create a Vlookup data table and reference the table...


    It would look like...

    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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