• Bringing Back Data from one worksheet to another

    From Mr dunn@21:1/5 to All on Tue Nov 5 22:08:09 2019
    Hi,

    I have been asked to match some data from one worksheet to another and I
    can't work out how to do it.

    In a nutshell.

    in one worksheet I have a column with product ID and next to it the manufacturer, in another I have a column of Product ID that we have
    sold, but I need to create a blank column named 'Manufacturer' and this
    should match up the data from the first worksheet.

    Does this make sense and can anyone help?

    1st worksheet

    Prduct ID Manufacturer
    1 Dunn
    2 Merry
    3 Christmas
    4 Excel
    5 Help

    2nd worksheet

    Product ID Manufacturer
    2 ?
    3 ?
    3 ?
    4 ?
    5 ?




    --
    Mr dunn

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)