Matching columns and retaining result data

[AndyT88]

I have a complete list of all sample ID's in column 1.

Column C shows the samples that have been tested for pH (and thier corresponding result in column D)



Column B is a duplicate list which inserts blanks using the following VBA code:

>>> use code - tags <<<

Sub Listduplicates()
    Dim rngA As Range
    Set rngA = Range([A1], Cells(Rows.Count, "A").End(xlUp))
    rngA.Offset(0, 1).Columns.Insert
    With rngA.Offset(0, 1)
        .FormulaR1C1 = _
        "=IF(ISNA(MATCH(RC[-1],C[1],0)),"""",INDEX(C[1],MATCH(RC[-1],C[1],0)))"
        .Value = .Value
    End With
End Sub

The question: How do I now get the pH result (column D) to match with its corresponding Sample ID in column A?

Any help will be greatly appriciated. Many Thanks.

 

[AlanSidman]

Cannot manipulate data in a picture. Please upload your sample file as an attachment.

crossposted: https://www.mrexcel.com/board/threads/matching-columns-and-retaining-result-data.1191182/
and https://www.excelforum.com/excel-pr...ns-and-retaining-result-data.html#post5611612

 

[vletm]

AndyT88
Please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences about Cross-posting.
Those are for You too.
Ps. Same kind of rules are everywhere.