Extracting a cell value

[James Smith]

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

 

[Pecoflyer]

Try using the VLOOKUP function or an INDEX/MATCH combination

 

[James Smith]

OK - got it - thanks