Extracting a cell value

Jan 5, 2018
Reaction score
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




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. After that, you can post your question and our members will help you out.

Ask a Question