Lookups - how to obtain data from a master spreadsheet into another

Discussion in 'Microsoft Office' started by tjb333, Dec 7, 2018 at 10:28 AM.

  1. tjb333

    tjb333

    Joined:
    Nov 22, 2018
    Likes Received:
    1
    Hi

    I have a large spreadsheet that will be used as the master copy that refreshes the data obtained from a system. I need to be able to extract this information into another spreadsheet and for this to continue to update as the information in the master spreadsheet is refreshed.

    I think I need to use Lookups but have researched this but can't seem to make it work.

    I have attached a dummy example if this helps but any advice will be appreciated. Currently, refreshing the data from a spreadsheet that has been modified (as per sheet 2) but this is causing too many problems as need to add traffic light system/conditioning format, so better to refresh the data on the master and look up this info up into the second sheet.
     
    tjb333, Dec 7, 2018 at 10:28 AM
    #1
    1. Advertisements

  2. tjb333

    tjb333

    Joined:
    Nov 22, 2018
    Likes Received:
    1
    wouldn't allow me to upload file :-(
     
    tjb333, Dec 7, 2018 at 10:31 AM
    #2
    1. Advertisements

  3. tjb333

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,395
    Location:
    Manchester
    Just to confirm my understanding, you have a master spreadsheet that you input data into, and you want to extract data from the master spreadsheet into a secondary spreadsheet... is that right? Also, so that I understand which part you want help with, does the formula work but doesn't refresh in the way you want, or does the formula not work?

    The forum software doesn't allow large attachments unfortunately, but you can take screenshots if that helps. Images should be fine, assuming they're not too large. Also if the spreadsheet contains personal or confidential information please make sure you redact as necessary before posting screenshots.
     
    Becky, Dec 7, 2018 at 10:46 AM
    #3
  4. tjb333

    tjb333

    Joined:
    Nov 22, 2018
    Likes Received:
    1
    Yes you are correct - the master spreadsheet gets updated with data and I want to select data from this spreadsheet into a secondary spreadsheet. I am not sure how to write the formula. Screen shots attached.

    I have lacked out some info for confidentiality reasons. I also will need to compare these spreadsheets month on month and present the differences but think that will need to be a different thread. Not sure if lookups can be used for this as well or whether I will need to use add in software
     

    Attached Files:

    tjb333, Dec 7, 2018 at 11:07 AM
    #4
  5. tjb333

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,395
    Location:
    Manchester
    Ok, thanks for the screenshots. Could you give me an example of something that isn't working, including the formula you're using?
     
    Becky, Dec 7, 2018 at 12:42 PM
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.