Search code examples
excelexcel-formulalibreoffice-calc

Fill data in excel sheet from master list from another sheet

I have data in two separate excel sheet in single file.

In the first sheet, I have two columns...like this

Sheet1

enter image description here

In the second sheet, I have one of the column which is same as Name in Sheet1. However, it does not have second column where I want to bring the value referring to the sheet 1.

Here is the second sheet.

enter image description here

Here in second column, i.e. Color I want to bring the value from first sheet.

I am using Libreoffice but can use excel as well. Pls suggest how I would do this in excel / libreoffice.

Solution

  • Solution for Excel...

    So use sheet one as the reference sheet. Sheet two as the one you want to fill.

    In B2 on Sheet 2 enter this formula:

    =vlookup(A2,Sheet1!$A$1:B$6$,2,FAlSE)

    Then drag down.

    This is assuming that your reference in sheet one is in columns A and B and goes from rows 1 to 6.

    Hope this helps.