Extracting a cell value

Discussion in 'Excel' started by James Smith, Jan 5, 2018.

  1. James Smith

    James Smith

    Joined:
    Jan 5, 2018
    Messages:
    2
    Likes Received:
    0
    I have 2 spreadsheets - one is Parent that has all the information and the 2nd is child that has a subset of the information. So, column A in the 2nd spreadsheet has list of computer names that matches entries in column A of the Master spreadsheet. Column B in the master spreadsheet has OS version. Column B does not exist in the child spreadsheet. What I want to do is:

    - for every computer name in the the child spreadsheet, search for it in the parent spreadsheet and return value of the corresponding OS. So, column B in the child spreadsheet gets populated thru the search process.

    Thanks - James
     

    Attached Files:

    James Smith, Jan 5, 2018
    #1
    1. Advertisements

  2. James Smith

    Pecoflyer

    Joined:
    Dec 29, 2017
    Messages:
    1
    Likes Received:
    0
    Try using the VLOOKUP function or an INDEX/MATCH combination
     
    Pecoflyer, Jan 6, 2018
    #2
    1. Advertisements

  3. James Smith

    James Smith

    Joined:
    Jan 5, 2018
    Messages:
    2
    Likes Received:
    0
    OK - got it - thanks
     
    James Smith, Jan 8, 2018
    #3
    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.